topic Re: Field Not Found When Converting Field to Text() in QlikView

Field Not Found When Converting Field to Text()

janturon — Mon, 22 Jan 2018 07:44:12 GMT

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,

...

...

Re: Field Not Found When Converting Field to Text()

zhadrakas — Mon, 22 Jan 2018 07:49:43 GMT

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,

Re: Field Not Found When Converting Field to Text()

janturon — Mon, 22 Jan 2018 08:00:48 GMT

Ooo Yes,

thank you very much.

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

Re: Field Not Found When Converting Field to Text()

janturon — Mon, 22 Jan 2018 08:01:53 GMT

It´s Monday....

Re: Field Not Found When Converting Field to Text()

zhadrakas — Mon, 22 Jan 2018 08:05:02 GMT

..

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

Force ‒ QlikView