Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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;
LOAD
USER
SubField(Filter,',') as Filter
FROM ......................
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;
See it is yesterdays thread.
Please explore forum before posting