Qlikview-SAP SQL Select Load statement issue

Kirti007 — Sat, 16 Nov 2024 19:53:38 GMT

Hi,

I am using following query: It gives me weird result. SQL load is not considering 'E' at the end of the customer string.

please help me find solution. I know this is happening because 0000037004 is getting loaded first and while loading 37004E, Qlikview considers it as same integer as previouly loaded.

When I load all records from customer table, I see 2 records as per below image.

ABC:
SQL Select
*
from CUSTOMER
Where CUSTOMER = '0000037004' or
CUSTOMER = '37004E'
;

Result:

Re: Qlikview-SAP SQL Select Load statement issue

Brett_Bleess — Tue, 22 Oct 2019 14:32:46 GMT

Kirti, I believe the correct solution on this one is to add Load statement in front of your SQL Select and use the Text() function on that field, that will ensure the leading zeros are maintained I believe.

So something like...

ABC:

Load Text(CUSTOMER) AS CUSTOMERTEXT...

SQL Select *...

Regards,
Brett

topic Re: Qlikview-SAP SQL Select Load statement issue in QlikView

Qlikview-SAP SQL Select Load statement issue

Re: Qlikview-SAP SQL Select Load statement issue