Trying to add last 4 columns together based on variable column names
Oct 8, 2012 2:20 PM(1351 views)
Hi there, I have a DT that is imported into jmp and what I am trying to create a formula to add the last 4 columns together. This is fine if the names where static and the dt had the same amount of columns but unfortunalty thiis is not the case.
The DT could have 7 to 10 columns dependent on the raw data pull and the column names are also variable. My question would be, is it possible to just create a formula for these last 4 columns and add them together, even if i didnt know the column names.
I have got the following to add specific columns:
/*Set Variables to the column locations */
a =column name(14);
b =column name(15);
c =column name(16);
d =column name(17);
/* Create a new column and add the 4 column variables together */