topic How to use wildcards in matching columns (Update Table) in Discussions

How to use wildcards in matching columns (Update Table)

UserID16644 — Mon, 04 Mar 2024 03:56:58 GMT

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

Code	Name	Age
ABCD456	Ann	12
ABCD123	Roy	16
ABCD678	Jean	11

TableB

Code	Name	Age
ABCD543	John	12
FGR263	Mike	13
ABCD975	Rose	8

After table update:

Code	Name	Age
ABCD456	Ann	12
ABCD123	Roy	16
ABCD678	Jean	11
ABCD543	John	12
ABCD975	Rose	8

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?

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

jthi — Mon, 04 Mar 2024 07:14:28 GMT

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?

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

UserID16644 — Mon, 04 Mar 2024 07:17:54 GMT

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