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

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.

ID1_ID2 Combined.png

Datasets

Accepted answers

CarliE

@l2decker

Attached is a workbook!

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

Thanks

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

All comments

Qiu

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

Can you give a try?

CarliE

@l2decker

Attached is a workbook!

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

Thanks

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

l2decker

Thank you, that worked perfectly!

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703