Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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;
Try loading the field as text like:
Load
Text(KEYFIELD) as KEYFIELD
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;
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;