I face the following challenge.
I needed to change the original data as I cannot post my workbook here.
I have table A ( main Table)
|Transport Mode (Key identifier)|
I need to joint it to a second table with the following two Key Identifier. Both are in one table:
I need to do a left join as I need all data from the main table and need to link it to the second table for additional information. I did a left join with Trans1 but for the identifier that do not match I would like to use Trans2.
Is there a custom SQL script I can use, I cannot have duplicates and empty fields in my main table.
If joint Trans1 is empty then joint Trans2?
Thank you for your help.
You need to Pivot your Both Columns of Second Table and and then you can Join. Better use Tableau PREP , But if you don't have much data can be done inside Tableau Desktop Too.