Join/Update Table Function Help

zrhelm17

Hello!

 

I am trying to execute a join (or an update) with columns that are referenced as a variable through a Parse(Eval( "String")) command either internal or external to the join command. I have multiple columns that I aim to match by but only the first set of matches is executing. See syntax below:

 

 

colNamething1 = Eval Insert( ":name(\!"^thing1^\!" )" );
colNamething2 = Eval Insert( ":name(\!"^thing2^\!" )" );

table3 = table1 << Join(
    With( table2 ),
    By Matching Columns(
        Parse( colNamething1 ) = Parse( colNamething1 ),
        Parse( colNamething2 ) = Parse( colNamething2 )
    ),
    Merge Same Name Columns
);

 

When I run the script only colNamething1 is being matched by. I have also tried executing the Parse(Eval Insert("String")) command external to the join and get the same result. Any suggestions on how to get around this? Thanks!

 

-Zac

ih

Can you try running the code below?  If this does not give the expected result, can you look in the 'source' script for the resulting table and see if that matches what you expect?

 

I am a little confused by colNamething1 would work in your script but not colNamething2. Maybe JMP is just happening to pick colNamething1 as a default column to join 

 

colNamething1 = "Name 1 As String";
colNamething2 = "Name 2 As String";

Eval( Eval Expr(
	table3 = table1 << Join(
		With( table2 ),
		By Matching Columns(
			Column( Expr( colNamething1 ) ) = Column( Expr( colNamething1 ) ),
			Column( Expr( colNamething2 ) ) = Column( Expr( colNamething2 ) )
		),
		Merge Same Name Columns
	)
) );