topic Re: Strings from SubStrings in table in QlikView

Strings from SubStrings in table

lylererger — Tue, 05 Aug 2014 10:26:24 GMT

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.

Re: Strings from SubStrings in table

Anonymous — Tue, 05 Aug 2014 10:33:34 GMT

LOAD

USER

SubField(Filter,',') as Filter

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

Re: Strings from SubStrings in table

sujeetsingh — Tue, 05 Aug 2014 10:37:40 GMT

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;

Re: Strings from SubStrings in table

sujeetsingh — Tue, 05 Aug 2014 10:38:34 GMT

See it is yesterdays thread.

Please explore forum before posting

Recurrence of all the words in a field