Two columns and FROM_FIELD

[Anonymous]

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

[MayilVahanan · Accepted solution]

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

[Anonymous]

Hi Mayil,

thanks, it helped me.

Olda