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
@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
@SouravKayal you could deal with multiple columns using a transpose tool, rather than creating more flows. Here's an example:
this does not work for my purpose my name value is not in the header but as values of a column