community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Consolidation of data sets using thee combination of keys

Highlighted
Alteryx Certified Partner

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

Magnetar
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