Hi,
I would like to merge 2 tables with the Table Transformer macro, but in the first table (Issues) there are multiple values (names and PIDs) in the Names field that I would like to use to merge it with the second table (Persons). I would like to merge the tables by PID. Here is an example in the picture.
So, my question is what would be the SQL for that. How can I get the PIDs from the Names field easily? And is it possible to merge these tables in one step?
Thanks,
Emil
Hi @[deleted],
I can suggest the following structure for your case:
Here is the SQL query for your Table Transformer macro:
SELECT * FROM T1
LEFT JOIN T2 ON T1.'Names'->indexOf(T2.'PID'+")") > -1
To group the result table in a more easy-to-read way, you may use the Pivot Table macro:
Hope it helps your case.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.