Conditional based joining two column values from different tables

Question

Hi all,

I am new to alteryx i have a scenario of containing two tables as shown below

Table 1:

EmpTypeCityAWorkBrazilAHometownALeave BWorkAmericaBLeave BHometownCWorkAfricaCHometownCLeave

&

Table 2 as below:

EmpHometownAAmericaBAfricaCBrazil

My expected output is joining only the city's where Type is hometown in the table 1 with Hometown in table 2 and must display as

EmpTypeCityAWorkBrazilAHometownAmericaALeave BWorkAmericaBLeave BHometownAfricaCWorkAfricaCHometownBrazilCLeave

Anybody help in this!!!!!!!

Regards,

Yoganantha Prakash G P

Thableaus · Accepted Answer

Hi @Yoga321

See solution

- Add a Record ID to original Dataset

- Transpose lookup HomeTown table

- Join the datasets by Emp and Type = Name (Hometown records)

- Union the Left Side (no hometown records) with Join Side (hometown records) - Auto Config by Position in this case

- Sort by Record ID to put everything in order.

- Deselect Record ID

WF appended.

Cheers,