Parameters Problem

blue1994

hello.
Very sorry for disturbing, i really don't know how to do it.
Can anyone help me if I want do the array/list, meant now i want to do array[1], then it output will be S_GX_F40, then in this S_GX_F40, it will contains I_P2A GSVT .6/.045 Avg and I_N2A GSVT.3/.045 Avg  extract from my excel file. I can do out if i use array[1], it can comes out the product name which is S_GX_F40 in log, but the parameter for tat product i still cannot get it.
So, may i know is it possible to do it?
I have try, but still cannot.
Can anyone answer me?
Thanks a lot.

 

ian_jmp

I'm not sure that I have understood what you are after (and I see you have given an Excel screenshot).

 

But if you read all the data into JMP, it may be that the code below gives you some ideas:

 

NamesDefaultToHere(1);

// Test Table
dt = New Table( "From Excel",
				Add Rows( 6 ),
				New Column( "F_ID",
					Character,
					"Nominal",
					Set Values( {"1", "1", "2", "2", "2", "3"} )
				),
				New Column( "Parameters",
					Character,
					"Nominal",
					Set Values( {"1", "2", "3", "4", "5", "6"} )
				)
			);

// Get the values into a list
ids = Column(dt, "F_ID") << getValues;
params = Column(dt, "Parameters") << getValues;

// Loop over the distinct IDs and show which parameters correspond
distinctIDs = AssociativeArray(ids) << getKeys;
for (id = 1, id <= NItems(distinctIDs), id++,
	thisID = distinctIDs[id];
	thisParam = params[Loc(ids, thisID)];
	Print("For parameter "||thisID||" the corresponding parameters are:", thisParam);
);