Concating every duplicate record

Hi All

I have the following dataset

ID	Food	Expiry Date
12345	Tomato	12 Jan
67890	Potato	23 Dec
53235	Cauliflower	8 Aug
12345	Pizza	6 June

How do I concat the Food and Expiry Date Collumn together so I can create a new collumn based on the ID and have the Expiry Date and Food collumn merged together per ID value? and then sort the concated values by order of date?

So i want to create something like the below

ID	Food	Expiry Date	Concated Values
12345	Tomato	12 Jan	12 Jan_Tomato \| 6 June_Pizza
67890	Potato	23 Dec	23 Dec_Potato
53235	Cauliflower	8 Aug	8 Aug_Cauliflower
12345	Pizza	6 June	12 Jan_Tomato \| 6 June_Pizza

Thanks in advance!

Preparation

Accepted answers

JosephSerpis

Hi @Alteryxuserhere you can you the summarise tool to concatenate your data then use the join tool to join the concatenated date back onto your orginal data. I have mocked up an approach which shows this.

Concatenate_18012024.yxmd

All comments

JosephSerpis

Concatenate_18012024.yxmd

Alteryxuserhere

Many thanks @JosephSerpis , can you explain the purpose of the record ID step?

JosephSerpis

Hi @Alteryxuserhere that is to sort your data back to what it looked like from the input.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703