topic Unexpected output while loading in QlikView

Unexpected output while loading

Anonymous — Wed, 13 Nov 2013 07:21:57 GMT

Hi,

For the below statement,

LOAD * INLINE [
F1
00222
0222
011
];

Ideally, the output should be :

00222

0222

011

However, we are getting the output as (refer to the attached image):

00222

011.

Please help.

Thanks,

Vijit

Re: Unexpected output while loading

kaushiknsolanki — Wed, 13 Nov 2013 07:24:58 GMT

HI,

Try this.

LOAD Text(F1) INLINE [

00222

0222

011

];

Regards,

Kaushik Solanki

Re: Unexpected output while loading

Wed, 13 Nov 2013 07:29:47 GMT

delete F1 and try it

Re: Unexpected output while loading

Anonymous — Wed, 13 Nov 2013 07:51:52 GMT

Thanks Guys. It's working fine.

Re: Unexpected output while loading

Anonymous — Wed, 13 Nov 2013 08:18:25 GMT

There's another query reference to my previous question.

I have a QVD Where I need to load as below:

MVKE:
LOAD
Text(MATNR) as Material,
Text(MATNR) & VKORG AS MRP_Key
FROM
$(v_MasterQVDPath)\MVKE.QVD(qvd)
where
match(VKORG,'A001','F001') and
match(VTWEG,'99') and
Len(Trim(KONDM))>0
and
Text(MATNR) = '0023128';

I have 2 Rows where MATNR = 0023128 & MATNR = 023128.

But, when we have a where condition as Text(MATNR) = '0023128' it returns 0 rows & when we have a where condition as Text(MATNR) = '023128' the load statement returns only 2 rows, but returns same values for both.

Re: Unexpected output while loading

Colin-Albert — Wed, 13 Nov 2013 08:18:46 GMT

The original result is due to the way that QlikView tokenises the data as it is loaded. QlikView stores all data as dual data types. For text data the numeric part is blank.

When loading your data, the first value encountered is 00222, so QlikView will store the text value as 00222 and the token for the numeric equivalent 222.

When the second value is loaded 0222, QlikView recognises that the equivalent numeric value 222 already exists, so only stores a pointer to the existing value.

This is why you get the same value returned for rows 1 and row 2. Numeric data will store the first value encountered for that number as the text portion of the dual data.

To prevent this use the text() function which forces QlikView to treat the data in the field as text, so the values 00222 and 0222 are recorded as separate values.

Re: Unexpected output while loading

kaushiknsolanki — Wed, 13 Nov 2013 08:22:02 GMT

Hi,

Try after removing the Text() in where condition.

Regards,

Kaushik Solanki