51147_zh-TW

liliconcom

將變量列列表製成表格

我正在使用以下內容生成一個列列表，該列表各不相同，但名稱中始終包含“X_Clean”：

col_list = dt<<GET column="" names="">0, i--,
  if(!contains(col_list[i], "X_Clean"),
    remove from(col_list, i);
  )
);</GET>

現在我正在嘗試創建一個表格框，但我不確定如何在分析列中引用這個 col_list。  

dtLUB= vlistbox(dt<< Tabulate(
 Change Item Label( Statistics( Max, " " ) ),
 Show Control Panel( 0 ),
 Add Table(
  Column Table( Analysis Columns( :Date ), Statistics( Max ) ),
  Column Table(
   Analysis Columns(
<FONT color="#FF0000">Need to insert col_list here somehow</FONT>
   ),
   Statistics( Max )
  ),
  Row Table( Grouping Columns( :Entity) )
 ),
 SendToReport(
  Dispatch(
   {},
   "Tabulate",
   OutlineBox,
   {Set Title( "PM Counter Summary as of: "|| TimeStamp )}
  )
 ),
));

回复：將變量列列表製成表格謝謝吉姆！回复：將變量列列表製成表格

這應該工作

dtLUB= vlistbox(dt<< Tabulate(
 Change Item Label( Statistics( Max, " " ) ),
 Show Control Panel( 0 ),
 Add Table(
  Column Table( Analysis Columns( :Date ), Statistics( Max ) ),
  Column Table(
   Analysis Columns(
    eval( col_list )
   ),
   Statistics( Max )
  ),
  Row Table( Grouping Columns( :Entity) )
 ),
 SendToReport(
  Dispatch(
   {},
   "Tabulate",
   OutlineBox,
   {Set Title( "PM Counter Summary as of: "|| TimeStamp )}
  )
 ),
));