Alteryx Designer Desktop Discussions

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

Need to create new unique data set by combining ID1 & ID2, with no common key

l2decker
5 - Atom

I have two tables of data that are completely different, but I need to merge them, repeating the data from ID 2 for each one of the unique identifiers in ID 1.

 

The combination will allow for downstream calculations. 

3 REPLIES 3
Qiu
21 - Polaris
21 - Polaris

@l2decker 
It seems to be a typical use case for Append tool.

Can you give a try?

Append.PNG

CarliE
Alteryx Alumni (Retired)

@l2decker 

 

Attached is a workbook!

 

 

Please mark a solution in which you found helped to solve your problem.

 

Thanks :)

Carli
l2decker
5 - Atom

Thank you, that worked perfectly!

Labels
Top Solution Authors