topic Re: SQL Select, keeping leading zero in QlikView

SQL Select, keeping leading zero

HermGerm — Sat, 16 Nov 2024 03:33:59 GMT

Im selecting a Table which contains values like this:

SQL-TABLE:

KEYFIELD VALUEFIELD

070 TEXT1

70 TEXT2

010 TEXT3

020 TEXT4

030 TEXT5

After Loading the Table inside Qlik is looking like this

QLIK-TABLE:

KEYFIELD VALUEFIELD

70 TEXT1

70 TEXT2

010 TEXT3

020 TEXT4

030 TEXT5

Problem is now, that Qlik is treating 070 the same as 70 and converts the 070 also to 70. How can i prevent qlik from doing this? It should extract the data exact like it is in the SQL.

Re: SQL Select, keeping leading zero

tresB — Thu, 16 May 2019 07:05:19 GMT

Try loading the field as text like:
Load
Text(KEYFIELD) as KEYFIELD

Re: SQL Select, keeping leading zero

HermGerm — Thu, 16 May 2019 07:42:00 GMT

Thank you, but this is not working or Im doing it wrong:

SQLTable:
SQL SELECT
ABTNR as 'KEYFIELD',
VALUEFIELD
FROM SQLTABLE;

MyTable:
LOAD
Text(KEYFIELD) as 'KEYFIELD',
VALUEFIELD
Resident SQLTable;

Drop Table SQLTable;

Re: SQL Select, keeping leading zero

tresB — Thu, 16 May 2019 07:47:02 GMT

That way, you probably would not find that table loaded. Try instead using preceding load like:

MyTable: LOAD Text(KEYFIELD) as 'KEYFIELD', VALUEFIELD ; SQL SELECT ABTNR as 'KEYFIELD', VALUEFIELD FROM SQLTABLE;