Alteryx Designer Desktop Discussions

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

Consolidation of data sets using thee combination of keys

farhana_91
7 - Meteor

Hi All,

 

I am currently facing an issue where I have three files to be consolidated. 

 

The combination of the columns I am looking for is:

Client Region Project ID Project

Now the three files have these common ID's.

 

However, data Set 1 has :

ClientRegionProject IDProject
AIMEA101Apple
AIMEA102Apple
AEurope101Apple
BIMEA201Orange
BIMEA202Orange
BEurope201Orange

 

Dats Set 2:

ClientRegionProject IDProject
AIMEA101Apple
AIMEA101Apple
AIMEA102Apple
AIMEA102Apple
AEurope101Aple
BIMEA201Orange
BIMEA202Orange
BEurope201Orange
BEurope201Orange
CUS300Kiwi

 

Whereas Client -C is not a part of Data Set 1&3

 

Data Set 3:

ClientRegionProject IDProject
AIMEA101Apple
AIMEA102Apple
AEurope101Apple
BIMEA201Orange
DAustralia401Jackfruit
EChina502Pineapple

 

Where as E is not there in Data set 1 & 2.

 

But my result should contain all the data with their measure as attached in the excel file.

 

Thanks in advance for you help.

 

Regards,

Farhana

1 REPLY 1
Claje
14 - Magnetar

The Join and Union tools are your friend for this kind of design.

I've attached a workflow that I think covers all your requirements.  Note that I made some assumptions about Data Set 2, and I also have 9 results instead of 8 (your example output did not have a "D" line).  I also fixed a typo in Data Set 2 as it was throwing off my results.

 

Hope this helps!

Labels
Top Solution Authors