New Table( "Untitled",
Add Rows( 60 ),
New Column( "Item",
Character,
"Nominal",
Set Values(
{"aim_lio", "aim_lio", "aim_lio", "aim_lio", "aim_lio", "aim_lio",
"aim_lio", "aim_lio", "aim_lio", "aim_lio", "aim_lio", "yeah_hoo",
"yeah_hoo", "yeah_hoo", "yeah_hoo", "yeah_hoo", "yeah_hoo", "yeah_hoo",
"yeah_hoo", "CC_act", "CC_act", "CC_act", "CC_act", "CC_act", "CC_act",
"CC_act", "CC_act", "bb_yoon", "bb_yoon", "bb_yoon", "bb_yoon",
"bb_yoon", "bb_yoon", "bb_yoon", "bb_yoon", "bb_yoon", "bb_yoon",
"bb_yoon", "bb_yoon", "bb_yoon", "bb_yoon", "lzh_hao", "lzh_hao",
"lzh_hao", "lzh_hao", "Ke_oh", "Ke_oh", "Ke_oh", "Ke_oh", "Ke_oh",
"Ke_oh", "he_low", "he_low", "he_low", "ge_green", "ge_green",
"ge_green", "ge_green", "Ye_kio", "Ye_kio"}
)
),
New Column( "ID",
Numeric,
"Continuous",
Format( "Best", 3 ),
Set Values(
[1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20,
21, 22, 23, 24, 25, 26, 27, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13,
14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 1, 2, 3, 4, 5, 6
]
),
Set Display Width( 93 )
),
New Column( "IDformula",
Numeric,
"Nominal",
Format(
"Custom",
Formula(
Repeat( "0", Maximum( 2 - Floor( Log10( value ) ), 0 ) ) ||
Format( value, "Fixed Dec", width, dec )
),
9,
0
),
Input Format( "Format Pattern", "" ),
Formula(
Col Rank(
1,
If(
Contains( {"aim_lio", "yeah_hoo", "CC_act"}, :Item ), 1,
Contains( {"bb_yoon", "lzh_hao", "Ke_oh", "he_low"}, :Item ), 2,
Contains( {"ge_green", "Ye_kio"}, :Item ), 3,
4
)
)
)
)
)
New Table( "Untitled",
Add Rows( 60 ),
New Column( "Item",
Character,
"Nominal",
Set Values(
{"aim_lio", "aim_lio", "aim_lio", "aim_lio", "aim_lio", "aim_lio",
"aim_lio", "aim_lio", "aim_lio", "aim_lio", "aim_lio", "yeah_hoo",
"yeah_hoo", "yeah_hoo", "yeah_hoo", "yeah_hoo", "yeah_hoo", "yeah_hoo",
"yeah_hoo", "CC_act", "CC_act", "CC_act", "CC_act", "CC_act", "CC_act",
"CC_act", "CC_act", "bb_yoon", "bb_yoon", "bb_yoon", "bb_yoon",
"bb_yoon", "bb_yoon", "bb_yoon", "bb_yoon", "bb_yoon", "bb_yoon",
"bb_yoon", "bb_yoon", "bb_yoon", "bb_yoon", "lzh_hao", "lzh_hao",
"lzh_hao", "lzh_hao", "Ke_oh", "Ke_oh", "Ke_oh", "Ke_oh", "Ke_oh",
"Ke_oh", "he_low", "he_low", "he_low", "ge_green", "ge_green",
"ge_green", "ge_green", "Ye_kio", "Ye_kio"}
)
),
New Column( "ID",
Numeric,
"Continuous",
Format( "Best", 3 ),
Set Values(
[1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20,
21, 22, 23, 24, 25, 26, 27, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13,
14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 1, 2, 3, 4, 5, 6
]
),
Set Display Width( 93 )
),
New Column( "IDformula",
Numeric,
"Nominal",
Format(
"Custom",
Formula(
Repeat( "0", Maximum( 2 - Floor( Log10( value ) ), 0 ) ) ||
Format( value, "Fixed Dec", width, dec )
),
9,
0
),
Input Format( "Format Pattern", "" ),
Formula(
Col Rank(
1,
If(
Contains( {"aim_lio", "yeah_hoo", "CC_act"}, :Item ), 1,
Contains( {"bb_yoon", "lzh_hao", "Ke_oh", "he_low"}, :Item ), 2,
Contains( {"ge_green", "Ye_kio"}, :Item ), 3,
4
)
)
)
)
)