Parsing columns to create new columns

[SouravKayal]

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

[JamesCharnley]

@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]

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

[SouravKayal]

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

[JamesCharnley]

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