topic Re: How to call multiple text file to extract data in a single data table? in Discussions

How to call multiple text file to extract data in a single data table?

kaushik_pushpen — Sun, 22 Feb 2015 17:22:24 GMT

I have extracted the useful data from one text file into a new data table using JMP script. But, how to extract data from 3-4 text file using script into a same new data table? Please suggest me.

Re: How to call multiple text file to extract data in a single data table?

Craige_Hales — Tue, 18 Oct 2016 22:37:01 GMT

If you used File->Open->TextFile to import a CSV, for example, there should be a script in the imported file that you can use/modify to import another file.

You can use JMP's Table->Concatenate to combine tables.


aa = Open( "C:\Users\User\Desktop\a.csv" );

bb = Open( "C:\Users\User\Desktop\b.csv" );

cc = aa << Concatenate( bb );

Close( aa, "nosave" );

Close( bb, "nosave" );

Re: How to call multiple text file to extract data in a single data table?

kaushik_pushpen — Mon, 02 Mar 2015 12:59:04 GMT

Hello Craige,

Thanks for the previous answer.

I am running the following variability script, but it is not showing the result. Please check the code.

dt1 = open("C:\Users\llenovo\Desktop\RAW1.jmp");

dt2 = open("C:\Users\llenovo\Desktop\Parameters.jmp");

dt3 = dt1<<summary(group(ParameterId, USL, LSL));

for(i=1, i<=2, i++,

for(k = 2, k<=nrow(dt3), k++,

if(:column(dt2, 1)) == column(dt3, 1),

usl = column(dt3, 2);

lsl = column(dt3, 3);

));

dt1 << Variability Chart(

Y( :MeasuredValue ),

X( :EntryDate, :LotID, :WaferNo ),

Analysis Type( Name( "Choose best analysis (EMS REML Bayesian)" ) ),

Std Dev Chart( 0 ),

where(:ParameterId == Eval((char(column(dt2, 1))))),

SendToReport(

Dispatch(

{"Variability Chart for MeasuredValue"},

"",

NomAxisBox,

Rotated Tick Labels( 1 )

Dispatch(

{"Variability Chart for MeasuredValue"},

"",

NomAxisBox( 2 ),

Rotated Tick Labels( 1 )

Dispatch(

{"Variability Chart for MeasuredValue"},

"",

NomAxisBox( 3 ),

Rotated Tick Labels( 1 )

Dispatch(

{"Variability Chart for MeasuredValue"},

"2",

ScaleBox,

{Min( 10 ), Max( 500 ), Inc( 50 ),Minor Ticks( 2 ),

Add Ref Line( usl, Solid, {255, 0, 0}, "lsllabel" ),

Add Ref Line( lsl, Solid, {255, 0, 0}, "usllabel" ), Show Major Grid( 1 ),

Show Minor Grid( 1 )}

);

Re: How to call multiple text file to extract data in a single data table?

Craige_Hales — Mon, 02 Mar 2015 14:12:55 GMT

Always check the log window for messages.

Add

Show(lsl, usl, i);

after the two nested for-loops and make sure the values make sense. I'm pretty sure "i" will be 3 and that might not make sense when used in the where statement. Does dt2 have at least 3 rows?

If that doesn't help, and no one else chimes in, call Tech Support. I'm out of my depth on the variability platform.