You can also use this to create a table with the elements from a list. a = { 1 , 2 , 3 , 4 , 5 } ; tmp = new table ( "test" , add rows ( nitems (a)) , new column ( "list A" , numeric , set each value(a[ row ()]))) ; ... View more

From the manual Infinite Loops For loops that always evaluate as true create an infinite loop, which never stops. To end the loop as the script runs, press ESC on Windows (or COMMAND-PERIOD on Macintosh). How do you start it again? ... View more

You can also use munger to change part of the name of a column. This is useful after "tabulate" or "summary" specially if you iterate through the different variables. eg one variable column (data_table ,2 ) << set name( munger ( munger ( eval ( char ( column (data_table ,2 ))) , 1 , "Column(\!"text_that_you_want_to_change " , "" ) , 1 , ")\!")" , "" )) ; eg all variables for (i = 1 , i <= n col (data_table) , i ++, column (data_table , i) << set name( munger ( munger ( eval ( char ( column (data_table , i))) , 1 , "Column(\!"text_that_you_want_to_change " , "" ) , 1 , ")\!")" , "" ))) ; ... View more

Thanks MS. That was great. Deeply appreciated. ... View more

The closest that I have found is update. The difference between join and update is that join creates a new table whereas update adds the columns to the first table. Col1 from table dt is the reference for col1 from table dt2. Col2 is the columns with the values that we want to add to table 1. dt << update (with (dt2), by matching columns (dt:col1==dt2:col1), add columns from update table(:col2)); ... View more

You can also do it with this script that is an alteration from //Jump into JMP Scripting //By: Wendy Murphrey and Rosemary Lucas // http://www.sas.com/apps/pubscat/bookdetails.jsp?catid=1&pc=61733 //Page 122, Soultion 5.16 In order to incorporate the source file name. Also a thread here I also incorporated some things from MS answer. MS, I was unable to use your script to finalize the concatenation. mypath = "C:\jmp\" ; Set Current Directory ( mypath ) ; y = Files In Directory ( mypath ) ; For ( i = N Items ( y ) , i > 0 , i --,   If ( Ends With ( y[i] , "txt" ) ,   ,   Remove From ( y , i )   ) ) ; n = N Items ( y ) ; For ( i = 1 , i <= N Items ( y ) , i ++,   sname = left (y[i] , length (y[i]) - 4 ) ; /* If the file is the first in the list, open it. Otherwise, open the table, concatenate with the main table, and close the table just opened. */     If ( i == 1 ,         mainDt = Open ( mypath || y[i] ) ;         mainDt << New Column ( "source" , character , set each value ( sname )) ,         dt = Open ( mypath || y[i] ) ;         dt << New Column ( "source" , character , set each value ( sname )) ;         mainDt = mainDt << Concatenate( dt , Append to First Table ) ;         Close ( dt , NoSave ) ;         Wait ( 0 ) ;     )   ) ;    /* Give the final table a name. */ mainDt << Set Name( "Concatenated Files" ) ; ... View more

That formula worked. Thank you very much. I was able to integrate it in my other more complex formula as in: "Variable 1"                     "Name"      "SharedVariable 1"      "Count of shared" CASSYGDGGTGELFF     John      Private                                   1 CATSRSSGYEQYF         John      Private                                   1 CASSPAAGAAYEQYF    John      Shared                                   3 CASSPAAGAAYEQYF    Albert     Shared                                   3 CASSVGSDAYEQYF      Albert     Private                                   1 CASSVGGVSYNEQFF    Albert     Private                                   1 CASSVSGSAYEQYF      Albert     Private                                   1 CASSPAAGAAYEQYF    Michael  Shared                                   3 New Column ( "SharedVariable1" ,          Character ,          Nominal ,          Formula( If ( ColNumber ( Hex To Number ( Char To Hex ( : Variable 1 ) ) , : Variable 1 ) > Col Number ( Hex To Number ( Char To Hex ( : Variable 1 ) ) , : Variable 1 || : Name ) , Char ( "Shared" ) , Char ( "Private" ))) ); New Column ( "Count of shared" ,          Numeric ,          Continuous ,          Formula(( ColNumber ( Hex To Number ( Char To Hex ( : Variable 1 ) ) , : Variable 1 ) - Col Number ( Hex To Number ( Char To Hex ( : Variable 1 )) , : Variable 1 || : Name )) + 1 ) ) One question: Col Number ( Hex To Number ( Char To Hex ( : Variable 1 ) ) is to create a countable variable. To specificy what to count is after the comma on the:       Col number(Column with a numeric variable, Condition to count) ... View more

Thanks PMroz, that was exactly what I did. I am trying to transfer all my data analysis from excel to JMP and there are some things that require this kind of workaround. Anyway, if there would be some column formula that could tackle this problem, it would be great. I will keep this discussion open for a little longer in order to see if there are any other suggestions. ... View more

If that would do it, sure. However, I am not very experienced in JMP and I have not used the SQL scripting. If anyone would be able to do it through the SQL and show it to me, I will be extremely thankful. Thanks art. ... View more