Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Conditional based joining two column values from different tables

Yoga321
7 - Meteor

Hi all, 

 

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

Table 1:

EmpTypeCity
AWorkBrazil
AHometown
ALeave 
BWorkAmerica
BLeave 
BHometown
CWorkAfrica
CHometown
CLeave 

 

Table 2 as below:

 

EmpHometown
AAmerica
BAfrica
CBrazil

 

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 

 

EmpTypeCity
AWorkBrazil
AHometownAmerica
ALeave 
BWorkAmerica
BLeave 
BHometownAfrica
CWorkAfrica
CHometownBrazil
CLeave 

 

Anybody help in this!!!!!!!

 

Regards,

Yoganantha Prakash G P

2 REPLIES 2
Thableaus
17 - Castor
17 - Castor

Hi @Yoga321 

 

See solution

 

Solution100.PNG

 

- 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,

Yoga321
7 - Meteor

Thanks Thableaus!!!!!

Labels