Strings from SubStrings in table

[lylererger]

Hi )

I've got source table:

The quantity of dividers ',' can be not limited!

And i need to transformate that table to get the next

 

Ok. I need to use SubField function, some Loops, CrossTable?

Help or any advice please!

Thnx.

[Anonymous]

LOAD

     USER

     SubField(Filter,',')         as Filter

FROM ......................

[sujeetsingh · Accepted solution]

Load rowno() as rowid, * inline [
field1, field2
two dog dog in the car two car, dog on the box
];

data2:
crosstable (field_source,field_data) Load * resident data;

data3:
Load
rowid,
field_source,
dual(subfield(field_data,' ',iterno()),rowno()) as field_word
resident data2
while iterno()<=SubStringCount(field_data,' ')+1;

drop table data2;

[sujeetsingh]

See it is yesterdays thread.

Please explore forum before posting

Recurrence of all the words in a field