Table Transformer macro - merging 2 tables by multiple values

[Emil]

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

[Katerina Rudkovskaya _Stiltsoft_]

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.