JSLを使用してシーケンスをデータテーブルの最後まで繰り返す方法は?不特定の数の行に対してこれを続けることができる行を選択するときに「列の最後まで埋める」でできるように、データテーブルの最後まで繰り返したい一連のシーケンスがあります
私は以下を使用しています:
NewColumn("Part", Character, Values({"1-B","1-B","1-B","1-D","1-D","1-D",
"1-F","1-F","1-F","1-H","1-H","1-H","1-J","1-J","1-J","1-L","1-L","1-L",
"2-B","2-B","2-B","2-D","2-D","2-D",
"2-F","2-F","2-F","2-H","2-H","2-H","2-J","2-J","2-J","2-L","2-L","2-L"}
));
Re: スクリプトの列の最後まで埋めるRepeat() を試してください。
2 つの例:
seq = {"1-B", "1-B", "1-B", "1-D", "1-D", "1-D", "1-F", "1-F", "1-F", "1-H", "1-H", "1-H", "1-J", "1-J", "1-J",
"1-L", "1-L", "1-L", "2-B", "2-B", "2-B", "2-D", "2-D", "2-D", "2-F", "2-F", "2-F", "2-H", "2-H", "2-H", "2-J",
"2-J", "2-J", "2-L", "2-L", "2-L"};
// Repeat sequence a predefined number of times
New Table( "example 2", New Column( "Part", Character, Values( Repeat( seq, 5 ) ) ) );
// Repeat sequence to fit an existing table
dt = New Table( "example", <<ADD rows=""></ADD>