Data Manipulation Quesion

I’m having trouble working out how to do some manipulations.
Any help gratefully received.
I have a table which looks like

Col0 Col1 Col2
A,B C,D E
F,G H,I J

And I want to get the table to look like
Col0 Col1 Col2
A C E
B D E
F H J
G I J

Its basically an unmerge on the columns
I can’t see how to do it.
Sorry for being stupid.
Thanks in advance
Cheers
Pash

Dear Pash

1- Open your data with File Reader
2- Use Node Column Filter, select the columns Cols1, Cols3 and Cols5
3- Use other Node Column Filter, select the column Cols2, Cols4 and Cols5
4- Use Node Rename for change name to the columns of one of results Filter Columns.
For example, after the first node used in item 2 in turn node Rename and change the
name of these columns respectively: Cols2, Cols4 and Cols5
5- Use Concatenate node for to conect the Column Filter used in item 2 with o rename used in item 4
6 - After conect Sorter node and choose for Col2

I ran these steps and it worked.
Hope I have helped


marcus@estanislao.com.br
Estanislao Training & Solution
Tel: (55 -11) 3070-3111
Tel/Fax: (55 -11) 5087-8867
Cel: (55 -11) 8331-5754
www.estanislao.com.br

Hi Marcus
That’s great. Thanks.
I see the logic I was missing

Cheers
pash