Creating a new column for grouping after splitting text to columns(rows)

Question

i have a date field that has the following inputs

ColumnA|B|CD|E|F|G

I want as below

ColumnGroupingAGROUP1BGROUP1CGROUP1DGROUP2EGROUP2FGROUP2GGROUP2

Able to split using text to columns-row feature,but how do i get the Grouping column?Any inputs would be appreciated.

JosephSerpis · Accepted Answer

Hi @arlok2005 I mocked up a workflow let me know what you think?

cmcclellan · Accepted Answer

Create a Record ID before the split, then just add GROUP and remove the Record ID field

grazitti_sapna · Accepted Answer

Hi @arlok2005 , try this.