Table Transformer - Join Tables with Multiple Matches

[Emily Berg]

Hello Community!

I have two tables I would like to combine - 

SR Key	PR Key
SR-51
SR-56
SR-3
SR-3524	PR-132

+

SR Key	PR Key
SR-51	SR-51
SR-56
SR-3	SR-3
SR-3524	SR-3524

=

SR Key	PR Key
SR-51	SR-51
SR-56
SR-3	SR-3
SR-3524	PR-132
SR-3524	SR-3524

I need to be able to keep match from both tables (see SR-3524 row).

Please help!!

Emily

[Katerina Kovriga _Stiltsoft_]

Hi @Emily Berg ,

We can suggest adding an extra step to the case - the Pivot Table macro.

Via the Table Transformer macro you simply merge the two tables as @Grigory Salnikov has suggested. And via the Pivot Table you group the result table by the SR Key.

Here we use the bullet point for items - so it is easy to see how the result table was grouped but you can always change it in the Pivot Table macro settings.

The second option may be using the Table Filter macro on top of the Table Transformer. There you may set the reversed filters and hide all the empty cells from the result table. But you will loose the SR-56 line - both PR keys for this SR key are empty. If you don't need such lines, then it may be another workaround for the case.

[Grigory Salnikov]

Hi @Emily Berg !

"Merge tables" should do or SQL query

select * from T*

[Emily Berg]

Hi @Grigory Salnikov

Unfortunately, that is not the output I am looking for - your suggestion returns the following:

[Grigory Salnikov]

I see now, thank you for pointing that out.

If keeping empty records is not necessary I would suggest the following:

select * from T* where 'PR Key' IS NOT NULL