生成随机字母你好,
我有一个打开数据集的脚本,其中有“操作员”列表。 我必须在“分析师”中手动为每个人分配一个随机字母,但想知道是否有一个代码可以循环所有不同的运算符并向分析师列分配一个随机字母?

谢谢!
自动化和脚本编写数据存取回复:生成随机字母@ian_jmp和@jthi你们俩都让这看起来很容易!谢谢你们的帮助:D
回复:生成随机字母一种选择是使用关联数组结合@ian_jmp解决方案。 像这样的事情可以工作:
Names Default To Here(1);
dt = New Table("test",
addrows(100),
New Column("Operator", character, set values({"ABC", "ABC", "DEF", "GHI"}));
);
// List of possible values
letterList = {"A", "B", "C", "D", "E", "F", "G", "H", "I", "J", "K", "L", "M", "N", "O", "P",
"Q", "R", "S", "T", "U", "V", "W", "X", "Y", "Z"};
uniq_oper = Associative Array(dt:Operator) << get keys;
Remove From(uniq_oper, Contains(uniq_oper, "")); // remove missing
uniq_oper_letter = letterList[Random Shuffle(1::N Items(letterList))][1::N Items(uniq_oper)];
oper_aa = Associative Array(uniq_oper, uniq_oper_letter);
dt << New Column("Analyst", character, << Set Each Value(
If(Contains(oper_aa, :Operator),
oper_aa[:Operator]
,
""
)
));回复:生成随机字母谢谢,我如何解释相同的运营商名称。 我会有多行,其中首字母为“ABC”,所以我希望所有这些都是相同的随机字母?
名称默认到这里(1);
dt=新表();
dt<<添加行(100);
dt<
// 可能值列表
letterList = {"A","B","C","D","E","F","G","H","I","J","K","L" ,"M","N","O","P","Q","R","S","T","U","V","W","X"," Y”,“Z”};
// 数据表的行数
n = 10;
// 分配给新字符列的值
colVals = letterList[RandomShuffle(1::n)];
打印(colVals);
dt<<新列(“分析师”,字符,设置值(colVals));
回复:生成随机字母这是一种方法。 请注意,“RandomShuffle()”确保您不会多次分配相同的字母(我认为这是您所需要的):
NamesDefaultToHere(1);
// List of possible values
letterList = {"A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z"};
// Number of rows in data table
n = 10;
// Values to assign to new character column
colVals = letterList[RandomShuffle(1::n)];
Print(colVals);