Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
lylererger
Creator II
Creator II

Strings from SubStrings in table

Hi )

I've got source table:

1.png

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

And i need to transformate that table to get the next

2.png 

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

Help or any advice please!

Thnx.

1 Solution

Accepted Solutions
sujeetsingh
Master III
Master III

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;



View solution in original post

3 Replies
Anonymous
Not applicable

LOAD

     USER

     SubField(Filter,',')         as Filter

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

sujeetsingh
Master III
Master III

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
Master III
Master III

See it is yesterdays thread.

Please explore forum before posting

Recurrence of all the words in a field