topic Using SubField in LOAD in QlikView

Using SubField in LOAD

Wed, 22 Aug 2012 21:24:57 GMT

Hi, I have this:

SET CenterType='Type1;Type2;Type3;Type4;Type5;Type6;Type7';

And then, I make a LOAD:

[ABC_XYZ]:

LOAD

@1 as xYear,

@2 as xMonth,

@3 as xDay,

SubField($(CenterType),';',Left(@4,1)) as TypeData

FROM

ABC.qvw.log

(txt, codepage is 1252, no labels, delimiter is spaces, msq)

;

But the 'SubFields' don't work.

Thanks.

fosuzuki — Wed, 22 Aug 2012 22:02:37 GMT

Try:

SubField('$(CenterType)',';',Left(@4,1)) as TypeData

Does Left(@4,1) return a numeric value?

Hope this helps

Fernando

Thu, 23 Aug 2012 02:00:39 GMT

That´s perfect !!.Thank you Fernando.