Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I don't know, how correct read data from this table:
TInput:
LOAD * INLINE [
one, two
1, 'A=1;B=3;C=4'
2, 'A=2;B=6'
];
I need create table so:
ID | VARIAB |
---|---|
1 | A=1 |
1 | B=3 |
1 | C=4 |
2 | A=2 |
2 | B=6 |
In tried FROM_FIELD with Transpose, but i get only one column (the second - Variab)
LOAD @1 FROM_FIELD (TInput, Variab) (no labels, filters(Transpose()), delimiter is ';');
And I need to have ID for each VARIAB.
Many thanks!
Olda
HI
Try like this
Load *,SubField(VARIAB,';') as Variab from tablename;
Edit:
Try like this:
LOAD *,SubField(two,';') as VARIAB INLINE [
one, two
1, 'A=1;B=3;C=4'
2, 'A=2;B=6'
];
Hope it helps
HI
Try like this
Load *,SubField(VARIAB,';') as Variab from tablename;
Edit:
Try like this:
LOAD *,SubField(two,';') as VARIAB INLINE [
one, two
1, 'A=1;B=3;C=4'
2, 'A=2;B=6'
];
Hope it helps
Hi Mayil,
thanks, it helped me.
Olda