412679_en-US

liliconcom

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

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];
);

 
Names Default To Here( 1 );
dt = Data Table( "Table A" );
dtOffset = Data Table( "Table B" );

colList = dt << get column names(string);

For( i = 1, i <= N Items( colList ), i++, 
 // Find the offset value in the dtOffset(Table B) data table
 // Because the column name from Table A may not have an offset
 // in Table B that has to be accounted for
 theRow = dtOffset << get rows where( dtOffset:Tests == colList[i] );
 show(i,nrows(therow));
 // If no rows are returned, no offset was found
 If( N Rows( theRow ) == 1,
  offset = dtOffset:Offset[theRow[1]];
  For( k = 1, k <= N Rows( dt ), k++,
   Column( dt, i )[k] = Column( dt, i )[k] + offset
  );
 );
</CODE></PRE><P><A href="https://community.jmp.com/t5/user/viewprofilepage/user-id/2687" target="_blank">@txnelson</A>&nbsp;<A href="https://community.jmp.com/t5/user/viewprofilepage/user-id/6657" target="_blank">@ih</A>&nbsp;<A href="https://community.jmp.com/t5/user/viewprofilepage/user-id/14366" target="_blank">@jthi</A>&nbsp;<A href="https://community.jmp.com/t5/user/viewprofilepage/user-id/6878" target="_blank">@Jeff_Perkinson</A>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P></LINGO-BODY><LINGO-LABS id="lingo-labs-412679" slang="en-US" mode="NONE"><LINGO-LABEL>Analytics</LINGO-LABEL><LINGO-LABEL>Scripting</LINGO-LABEL></LINGO-LABS><LINGO-SUB id="lingo-sub-413205" slang="en-US" mode="NONE">Re: Add values from another data table file to current data table file</LINGO-SUB><LINGO-BODY id="lingo-body-413205" slang="en-US" mode="NONE"><P>Well, its not just me. I have seen similar posts before</P></LINGO-BODY><LINGO-SUB id="lingo-sub-413030" slang="en-US" mode="NONE">Re: Add values from another data table file to current data table file</LINGO-SUB><LINGO-BODY id="lingo-body-413030" slang="en-US" mode="NONE"><P>The Community Discussion Forum is not a place to go to to have JMP scripts written for you!&nbsp; You need to take the time to learn JSL, and to use the Discussion Forum to help you with specific issues you are not understanding.</P></LINGO-BODY><LINGO-SUB id="lingo-sub-413029" slang="en-US" mode="NONE">Re: Add values from another data table file to current data table file</LINGO-SUB><LINGO-BODY id="lingo-body-413029" slang="en-US" mode="NONE"><P>The log file entry from when your code is run is:</P>
<PRE>not enough arguments in access or evaluation of 'For' , For/*###*/(i = 1 ; N Rows( dt ) ; i++, Column( dtOffset )[i] = dt:colList[i]
+dtOffset:Offset[i])

at line 7 in Script 5.jsl</PRE>
<P>What this is telling you, is that the For() function syntax that you are using is incorrect.</P>
<P>The correct definition can be found in the Scripting Index, or in the Scripting Guide.&nbsp; Also, if you look at your implementation of the For() function, and the sample I provided, your version is not the same.</P>
<P>Your solution is going to require that you loop across the columns in your Table A.&nbsp; For each column you will need to get the Offset value that needs to be applied to the values in the Table A column, and then loop through all of the rows in that column, applying the correct offset.<CODE class=" language-jsl">

 

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

Hi @ih,

 

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. There are more than 100 columns in Table A. How can I use a loop syntax to iterate to each rows and columns?

Here's what I've tried to start with

 

Names Default To Here( 1 );
dt = Data Table( "Table A" );
dtOffset = Data Table( "Table B" );

colList = dt << get column names;

For(i=1; N Rows(dt); i++,

 Column(dtOffset)[i] = dt:colList[i] + dtOffset:Offset[i];
 
);

Appreciate if you could suggested

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

@txnelson 

 

Here is what I tried. Im not sure what's wrong. Can you please take a look?

 

Names Default To Here( 1 );
dt = Data Table( "Table A" );
dtOffset = Data Table( "Table B" );

colList = dt << get column names;

For(i=1; N Rows(dt); i++,

 Column(dtOffset)[i] = dt:colList[i] + dtOffset:Offset[i];
 
);

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

You can use

colList = dt << get column names;

to get the names of the columns in the data table

and then use a For() loop 

For(i=1,i<=N Items(colList), i++,
.......
.......
.......
);

to perform the operations you need to do for each column.

These are documented in the Scripting guide and Scripting Index......with examples

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

How can I use a loop to perform addition. There are more than 100 columns in Table A?

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

Many Thanks @txnelson you are genius

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

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];
   );