I would like to label my graphs with the values and column names for that point (as in a box plot). Currently I do this in Excel by concatenating the column name with the value in the cells. However, if I can do it in JMP, it would save me a significant amount of time.
For example I may have columns
A B C
1 2 100
1 2 200
2 5 300
I would like to create a new column that describes the information in the other columns:
A = 1 : B = 2 : C = 100
A = 1 : B = 2 : C = 200
A = 2 : B = 5 : C = 300
So far I have been able to create a list with the column names, but am unable to figure out how to iterate and concatenate the other values.
cdt = Current Data Table();
ColNames = {};
ThisLabel = {};
ColNames = cdt << Get Column Names( string );
for(i=3;i<=5;i++)
concat(ThisLabel,ColNames[i]);
// more work is required to get the values from the table
Thank you in advance
