Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I'm encountering an issue during a load from an AS/400. The data type in the AS/400 for a Ship-to code is Alpha in many cases those codes can be numeric values however when loaded to QlikView I'm getting strange results. See chart below:
As Represented in the AS400 | As Represented in QlikView |
1 | 00000001 |
00000001 | 00000001 |
Any ideas on how to suppress this conversion and retain the original data representation?
Rich
Try a text(FIELD), like in
LOAD
text(FIELD) as FIELD,
...
Thank you.