Add values from another data table file to current data table file

Jackie_

Hi,

 

Hi, I have a doubt regarding JSL script (very new to this!)

 

I've two data files- Table A and Table B.

Table A:-

   

Table B:-

 

I want to add values from Table B Column name "Offset" to each Rows of Column Group "Tests" in Table A and generate a new data table file with values added.

P.S.- There are more than 100 columns in the Table A file. How can I use a for loop to iterate all rows and columns? 

Here's what I've tried to start with. Any ideas on this or a more efficient way to do it?

 

</CODE></PRE><PRE class="language-jsl"><CODE>Names Default To Here( 1 );
dt = Data Table( "Table A" );
dtOffset = Data Table( "Table B" );

For Each Row(
	dt:Current = dt:Current + dtOffset:Offset[1];
	dt:Voltage = dt:Voltage + dtOffset:Offset[2];
	dt:Resistance = dt:Resistance + dtOffset:Offset[3];
	dt:Inductance = dt:Inductance + dtOffset:Offset[4];
	dt:Capacitance = dt:Capacitance + dtOffset:Offset[5];
	dt:Power = dt:Power + dtOffset:Offset[6];
	dt:Temperature = dt:Temperature + dtOffset:Offset[7];
	dt:Humidity = dt:Humidity + dtOffset:Offset[8];
	dt:Pressure = dt:Pressure + dtOffset:Offset[9];
	dt:Suseptance = dt:Suseptance + dtOffset:Offset[10];
);

@txnelson @ih @jthi @Jeff_Perkinson 

 

 

Table B.jmp

Table A.jmp

txnelson

1. Please take the time to read the Scripting Guide and to familiarize yourself with the Scripting Index.
2. If you need to brush up on general programming skills, there are a large number of sites on the internet that can assist with that.
3. Here is the simple script that will do what you want

   Names Default To Here( 1 );
   dt = Data Table( "Table A" );
   dtOffset = Data Table( "Table B" );
   
   For Each Row(
   	dt:Current = dt:Current + dtOffset:Offset[1];
   	dt:Voltage = dt:Voltage + dtOffset:Offset[2];
   	dt:Resistance = dt:Resistance + dtOffset:Offset[3];
   	dt:Inductance = dt:Inductance + dtOffset:Offset[4];
   	dt:Capacitance = dt:Capacitance + dtOffset:Offset[5];
   	dt:Power = dt:Power + dtOffset:Offset[6];
   	dt:Temperature = dt:Temperature + dtOffset:Offset[7];
   	dt:Humidity = dt:Humidity + dtOffset:Offset[8];
   	dt:Pressure = dt:Pressure + dtOffset:Offset[9];
   	dt:Suseptance = dt:Suseptance + dtOffset:Offset[10];
   );