topic Re: LOAD list ';' separate like lines in QlikView

LOAD list ';' separate like lines

MarcoARaymundo — Wed, 08 May 2013 18:58:35 GMT

Hi!

I have a field that the content is separated text. (1;2;3).

And now I need to transform this field in lines.

Field

Is it possible?

Gysbert_Wassenaar — Wed, 08 May 2013 19:00:25 GMT

You can use the subfield function for this:

Load subfield(Field1, ';') as Field1;

Select Field1 from ...somewhere..,;

MarcoARaymundo — Wed, 08 May 2013 19:14:32 GMT

Thank you! but this is not what I need, see:

I have Field1 = 1;2;3 (select field1 from oracle)

I need "explode" field1 to..

I know there is a way to do this, but do not know how to do it.