Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Alpha Content Converts to Numeric

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 AS400As Represented
  in QlikView
100000001
0000000100000001

Any ideas on how to suppress this conversion and retain the original data representation?

Rich

1 Solution

Accepted Solutions
MVP
MVP

Re: Alpha Content Converts to Numeric

Try a text(FIELD), like in

LOAD

     text(FIELD) as FIELD,

     ...

2 Replies
MVP
MVP

Re: Alpha Content Converts to Numeric

Try a text(FIELD), like in

LOAD

     text(FIELD) as FIELD,

     ...

Not applicable

Re: Alpha Content Converts to Numeric

Thank you.

Community Browser