Early bird tickets for Inspire 2023 are now available! Discounted pricing closes on January 31st. Save your spot!

Alteryx Designer Discussions

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

Parsing columns to create new columns

SouravKayal
8 - Asteroid

Hi Team,

 

I have a column of data in a text like

 

Column name:

abcde;def;567;name1:bk;name2:bh

 

I would want to take out values name 1 as a column with value as bk and name 2 as a column with value as bh 

 

the column has a lot of bad data as well.

 

what is the best way to achieve this

13 REPLIES 13
JamesCharnley
12 - Quasar

@SouravKayal  I think all you'll need to do is add a transpose step to the start of the workflow to turn all of the columns into rows

FinnCharlton
11 - Bolide

@SouravKayal you could deal with multiple columns using a transpose tool, rather than creating more flows. Here's an example:

FinnCharlton_0-1674663627102.png

 

SouravKayal
8 - Asteroid

this does not work for my purpose my name value is not in the header but as values of a column

JamesCharnley
12 - Quasar

@SouravKayal  you just have to add a transpose as mentioned before any parsing steps begin.

 

JamesCharnley_0-1674666660386.png

 

Labels