Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
In data base i have 2 codes - 501 and 501.00000 but when loading this code through SQL select in qlik , qlik is returning only 501.00000(it is eliminating 501).
can you please help me with that
You need to enforce a string-interpretation of this field, for example with:
load text(code) as code;
sql select code from source;
- Marcus
You need to enforce a string-interpretation of this field, for example with:
load text(code) as code;
sql select code from source;
- Marcus