I would like to stack a list of columns based on a table variable, but I'm having trouble figuring out how to format the variable and the script
//this is my table variable -- I've called it myList
{"colName1", "colName2"}
//this is my script
dt = Current Data Table();
dt << Stack(
columns(myList),
Output Table( "New Table" )
);
I have a table with column names colName1, colName2, colName3...
And I would like to be able to stack only certain columns based on a table variable list. I've been able to do this by grouping columns then stacking the whole group, but I've run into situations where I may want to stack a subset of a group of columns, hence this attempt.
The list and script above gives me the error: "Column not found in access or evaluation of bad argument"
I've also tried changing the command to
columns(eval(myList))
but that gives me the same error