Using column data to script table edits

fwissman

Hi - I apologize if this is trivial.

I have created a table SublotList from Sublot Control Data that is a single column of Sublots, they are mixed alphanumeric and not known until the original table is pulled.  I would like to use the Sublot found in the 1st row of SublotList and use it in my Select Where statement and also in the Output Table name. Then I want to step through all Sublots and quit when I use the last Sublot.  Roughly said, I'm manually entering "-A",   -A, "-L22", or -L22, etc. in many select and naming statements and would like to use these values from a separate table. I'm sure this question isn't fully formed yet, please ask questions. Thank you.

 

dt1<< Select Where (:SubLot == "-A");

Data Table( "Sublot Control Data" ) <<

Subset(

Output Table( "-A Sublot Control Data" ),

Selected Rows( 1 ), ,

Selected columns only( 0 ));

 

uday_guntupalli

@fwissman , 

  Here I think this is what you are after . Let me know : 

// Define Paths (edit this as needed) 
SubLotControlFilePath = "C:\Users\Sublot Control Data.jmp" 
SublotListFilePath = "C:\Users\Sublot List.jmp" ;

// Open Files 
dt_SublotControl = Open(SubLotControlFilePath);
dt_SublotList = Open(SublotListFilePath);

// Get List of sublots
SubLotList = dt_SublotList:SubLot << Get Values; 

// If you want to select all rows where sublots match sublot list 
dt_SublotControl << Select Where(Contains(SubLotList,:SubLot)); 

// If you instead want to select rows based on subplot one after the other 
for( i = 1 , i <= N Items(SubLotList) , i++, 
		dt_SublotControl << Select Where(:SubLot == SubLotList[i]); 
		dt_Temp = dt_SublotControl << Subset(""); 
		dt_Temp << set Name(Concat("Subplot-",SubLotList[i]));
   );