Create new columns by loop formula calculation with specific column names
Hello dear jmp experts/users,I have a fixed format data table with similar column name formats like this (always similar two column name distinguished by _1):NAME, C1, P2 ... C1_1, P2_1 .... (actually many columns with this naming rule) I'd like to create new columns with below formula: for exampe,C1_cal by : C1-C1_1P2_cal by : P2-P2_1...how do i use JSL to achieve loop for this? Thanks a lot!