cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar
UserID16644
Level V

How to use wildcards in matching columns (Update Table)

Hi all,

How can I update a table using wildcard? I already tried to create a column with a substring formula

dt << New Column( "Code Ref", Formula (Substr(:Code, 1, 4)) );

TableA

CodeNameAge
ABCD456Ann12
ABCD123Roy16
ABCD678Jean11

 

TableB

CodeNameAge
ABCD543John12
FGR263Mike13
ABCD975Rose8

 

After table update:

CodeNameAge
ABCD456Ann12
ABCD123Roy16
ABCD678Jean11
ABCD543John12
ABCD975Rose8

 

But I cannot use Code Ref as matching columns when I use the UPDATE table because it results into blank columns. How can I use wildcards to update table in matching columns?

2 REPLIES 2
jthi
Super User

Re: How to use wildcards in matching columns (Update Table)

You cannot really use wildcards in JMPs Join/Update platforms (you could use SQL query to join the tables though) but I'm not exactly sure what type of update you are trying to perform? Are you trying to concatenate only rows which have Code starting with ABCD?

-Jarmo
UserID16644
Level V

Re: How to use wildcards in matching columns (Update Table)

I am trying to update TableA with TableB using the Code column. I could also be needing some columns from TableB that should be in TableA