I am using the following to generate a column list, which varies but always has an "X_Clean" in the name:
col_list = dt<<get column names(string);
for(i=nitems(col_list), i>0, i--,
if(!contains(col_list[i], "X_Clean"),
remove from(col_list, i);
)
);
Now I'm trying to create a tabulate box but I'm unsure how to reference this col_list in the Analysis Columns.
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(
Need to insert col_list here somehow
),
Statistics( Max )
),
Row Table( Grouping Columns( :Entity) )
),
SendToReport(
Dispatch(
{},
"Tabulate",
OutlineBox,
{Set Title( "PM Counter Summary as of: "|| TimeStamp )}
)
),
));