Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
qvhlaold0
Contributor III
Contributor III

Two columns and FROM_FIELD

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:

IDVARIAB
1A=1
1B=3
1C=4
2A=2
2B=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

1 Solution

Accepted Solutions
MayilVahanan

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

Thanks & Regards,
Mayil Vahanan R

View solution in original post

2 Replies
MayilVahanan

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

Thanks & Regards,
Mayil Vahanan R

View solution in original post

qvhlaold0
Contributor III
Contributor III
Author

Hi Mayil,

thanks, it helped me.

Olda