生成隨機字母你好,
我有一個打開數據集的腳本,其中有“操作員”列表。 我必須在“分析師”中手動為每個人分配一個隨機字母,但想知道是否有一個代碼可以循環所有不同的運算符並向分析師列分配一個隨機字母?

謝謝!
自動化和腳本編寫數據存取回复:生成隨機字母@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);