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

Tips and Tricks

Accepted answers

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

All comments

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.

Hi @Barclaysusercds

One way of doing this.

Step 1: Input

Step 2:

Step 3:

Many thanks

Shanker V

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

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15878

MarqueeCrew 13708

apathetichell 13703