Data Analytics- comparing excel data with unique identifiers with numerous records?

[Bmthred1980]

• Hi all, fairly new to data analytics and Alteryx, looking for some help?

I have pulled data using a power query and now have two sets of excel data which have the same unique identifiers. I require help in building an Alteryx workflow which can compare the records from both sources. The challenge is the unique identifier has several records of different values rather then just one row?

Cheers Leigh

[binuacs · Accepted solution]

@Bmthred1980 you can bring both your data sources using the input tool and connect to a join tool to compare

[Raj · Accepted solution]

Join tool will help you to achieve your desired result.

you can refer to the Example attached with it and if still you need assistance, you can add sample files, Happy to help.

[kamal03 · Accepted solution]

Please share sample input and output files if possible, I think this is possible.