189153_zh-TW

liliconcom

Re：需要JSL腳本幫助 - 概括拆分列

我這部分：

//Step 3: Split data (this part is not working)
rd_split = rd_summary << Split(
       Split By( :Treatment ),
       Split( SummaryMetricNames),
       Group( :Participant Name ),
       Remaining Columns( Drop All ),
       Sort by Column Property
)

問題在於SummaryMetricNames。 不評估此變量。 ... 並且您需要將每個列名稱（逗號分隔）放入split（）中的split（）中。

 

dt=current data table();
dt<<GET column="" names=""></GET>

我可以遍歷列名列表並將每個列分別插入到表達式拆分器中，但這一行在一步中完成相同的操作

insert into (splitter, substitute ( cols , expr(split({})), expr( split()))); 

需要JSL腳本幫助 - 推廣拆分列

我試圖概括分割數據表中的列，可以有任意數量的列進行拆分。  我通過查找“參數”這個詞來識別它們。我相信，當我引用SummaryMetricNames時，我在第3步中做錯了。  

 

先感謝您！

 

 

//Step 1: Get the means of columns in ColList (select metric columns from a table I got using Get Column Names)
rd_summary = rd << Summary(
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Group( :Participant Name, :Treatment ),
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Mean( ColList),
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Freq( "None" ),
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Weight( "None" ),
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; statistics column name format( "column" )
);

//Step 2: Get list with just means columns from the table
SummaryMetricNames = rd_summary << Get Column Names;

For( i = N Items ( SummaryMetricNames ), i>=1, i--,
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If ( Contains( SummaryMetricNames[i],"Parameter" )==0,
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SummaryMetricNames = Remove( SummaryMetricNames, i, 1 )
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; )
);

//Step 3: Split data (this part is not working)
rd_split = rd_summary << Split(
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Split By( :Treatment ),
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Split( SummaryMetricNames),
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Group( :Participant Name ),
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Remaining Columns( Drop All ),
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sort by Column Property
);