topic Re: Two columns and FROM_FIELD in QlikView

Two columns and FROM_FIELD

Anonymous — Mon, 05 Nov 2012 20:08:20 GMT

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

Re: Two columns and FROM_FIELD

MayilVahanan — Mon, 05 Nov 2012 20:11:52 GMT

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

Re: Two columns and FROM_FIELD

Anonymous — Mon, 05 Nov 2012 22:59:19 GMT

Hi Mayil,

thanks, it helped me.

Olda