Delimit and bring to one line

[Barclaysusercds]

Hi,

See screen below for illustration. For the maintradeid 210337342 there are many alternateids (column B-G) which I extracted with the demit function in alteryx. How can I get all the alternateids into one row. Currently my alteryx workflow brings each alternate id into a separate row but I want all in one row. I have included a second screen shot which is my alteryx workflow.

Thanks

[ShankerV]

Hi @Barclaysusercds 

You can use the summarize tool to get the desired output.

Can you please share the input in copy and paste format.

Many thanks

Shanker V

[Barclaysusercds]

I did use the summarize and it brought it onto different rows.

[ShankerV]

Hi @Barclaysusercds 

One way of doing this.

Step 1: Input

Step 2: 

Step 3:

Many thanks

Shanker V

[binuacs · Accepted solution]

@Barclaysusercds In summarise tool Group by up to sectype field then for the rest of the field take the max value