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

[arlok2005]

i have a date field that has the following inputs

Column

A|B|C

D|E|F|G

I want as below

Column	Grouping
A	GROUP1
B	GROUP1
C	GROUP1
D	GROUP2
E	GROUP2
F	GROUP2
G	GROUP2

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

[JosephSerpis · Accepted solution]

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

[wdavis]

Hi @arlok2005 

To do this, you can apply a RecordID at the start of the workflow to provide your groups. Then using a Text to Columns tool you can 'Split to Rows' which will get the table you are after!

I have attached a workflow which replicates this. Let me know if this works.

Kind Regards

Will

[cmcclellan · Accepted solution]

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

[grazitti_sapna · Accepted solution]

Hi @arlok2005 , try this.