Formatted text fields Script

[ezec1807]

Good .
I am running in one query raising Script fields that come with varchar format ( alphanumeric ) from a database of SQL Server. It is a field with a value eg . " 000245 " and is associated with the name " Maria " field and a value " 245 " into the field "John" . What makes me qlikview two values ​​is Mary and John with the value 245 , instead of showing " 000245 " to Mary and " 245 " for John.
Someone can help me?

Thank you!

Cheers,
Ezequiel

[swuehl]

You'll need to force QV to look at 000245 and 245 as distinct text values instead of numbers, i.e. using

LOAD

  Text( YourField ) as YourField,

    ...;

SELECT YourField, ... FROM ....;

[ezec1807]

Hi.
That works. But qlikview can not import the field as text ( as it is in the SQL database server) ?
Not configurable this, in the tool ?

Thank you!

[swuehl]

It will use automatic interpretation, like described here

Automatic Number Interpretation

[ezec1807]

Thank you very much for the help!

Cheers,
Ezequiel