Hi All,
I have a data table and I want to run a loop to get all the columns and place it in the tabulate function. Basically it has column name as 1,2,3,4,5...and the contents are random PASS or FAIL.
I came across this blogpost which was useful (https://community.jmp.com/t5/Discussions/How-do-I-have-tabulate-iterate-through-multiple-columns-using/m-p/15418#M14139) but instead of having by grouping columns, is it possible to have a simple table having column names(1,2,3,4...) as the first column and % total of each column with fail/pass next to it.
Here is the code I used:
col_list = current data table()<Show(col_list);
tab = current data table()<// Add grouping columns in cList/
For (c=1, c<=NItems(col_list), c++,
tab << Add table(Row Table( Grouping Columns( col_list[c] ) ));
);
Attached is a picture which shows that the left table is the one I get, the right table is what I want. Thank you.
