Concatenate with ; in between each term

BillyL14

Hi there

I need to change my data in row 3 to look like it does in row 4. Please see my sample.

How can I do that in Alteryx?

Thanks

Concatenate with ; in between.xlsx

Accepted answers

David-Carnes

Same thing, but concatenate both field and value in the Summarize, then peel off the field names and data from each other and stack them with the Union tool set to Autoconfig by Position.

4 WL1 (3).png

(edited to add file)

For WL1.yxmd

Emil_Kos

Hi @BillyL14,

Got it. This time it should work for you!

Concat.yxmd

All comments

Emil_Kos

Hi @BillyL14,

Hope this is helpful.

Concat.yxmd

David-Carnes

Here's another way but @Emil_Kos 's solution is cleaner, IMHO.

4 WL1.png

For WL1.yxmd

BillyL14

@David-Carnes @Emil_Kos

Thanks both for those, very helpful

I forgot to mention that I need the titles of the columns to also be combined, like in my updated sample, would that also be possible?

thanks again

Concatenate with ; in between (2).xlsx

David-Carnes

I'm sure @Emil_Kos will come up with something better, in the meantime...
Split out the Names and concatenate them, then Union the rest to it.

4 WL1 (2).png

For WL1.yxmd

David-Carnes

Same thing, but concatenate both field and value in the Summarize, then peel off the field names and data from each other and stack them with the Union tool set to Autoconfig by Position.

4 WL1 (3).png

(edited to add file)

For WL1.yxmd

Emil_Kos

Hi @David-Carnes,

I don't think there is a better solution than the second one that you have proposed. Hope you don't mind as I have used your find to add additional functionality that might be useful for @BillyL14.

In case you want the header to still be a header you need to use the dynamic rename tool to achieve that.

For WL1v2.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703