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

Alteryx designer Discussions

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

Merge and combine

Asteroid

How do I merge and combine records from the same customer whose customer ID has changed but unique id has stayed the same. For the customer below I would like to merge all the customer records into one and use the unique ID (28) as the single identifier. Thanks

 

Customer IDUnique IDCustomer EnrollmentProd TypeItems Purchased
52812/31/2018IPOTops
52812/31/9999PSkirts
62812/31/2018IPOTops
62812/31/9999PSkirts
Alteryx
Alteryx

You can use the unique tool on Unique ID and it will pick the first row of each Unique ID that exists. Would this be sufficient, or are there other variations in the data that need to be accounted for?

Labels