Field Not Found When Converting Field to Text()

[janturon]

Hi,

I need to convert field hk_US to text, because QlikView automaticly takes this field (when is without cast...) as Num and makes TOTALS which I dont want. For example If values are 31 and 031, Qlik merge this values to 031.

I used script like below... But always have Error code Field not found.

P.S. Select is from ORACLE

TABLE:

LOAD

  Text (hk_US) as hk_USyn,

$(vminobd) as OBDOBIE,

    *;

SQL

SELECT

UCTY.ID,

cast (UCTY.UCET as varchar(10)) as hk_US,

...

...

[zhadrakas · Accepted solution]

try in upper case

TABLE:

LOAD

  Text (HK_US) as hk_USyn,

$(vminobd) as OBDOBIE,

    *;

SQL

SELECT

UCTY.ID,

cast (UCTY.UCET as varchar(10)) as hk_US,

[janturon]

Ooo Yes,

thank you very much.

I forgot that ORACLE always names fields with UPPER CASE signs.

[janturon]

It´s Monday....

[zhadrakas]

..

you can override this Setting with the force function if needed.

Force ‒ QlikView