topic Data type changed whil Qlik loading in QlikView

Data type changed whil Qlik loading

oxiofrt — Mon, 08 Feb 2010 11:13:52 GMT

Hi,
I try to load a varchar dimension. Some of its values may be '13' or '013'. Those two values are different and should remain different in my application.
I tried to load them with an SQL statement and with a load statement (even tried to include a text() fonction ).

In both cases, Qlikview does consider 13 and 013 as the same dimension...
How may I proceed ?

See attachment.
Thanks a lot for your help !

Data type changed whil Qlik loading

sparur — Mon, 08 Feb 2010 12:21:36 GMT

Hi, oxioFRT.

See in attachment. 🙂

I think that your problem is solved.

Data type changed whil Qlik loading

oxiofrt — Tue, 09 Feb 2010 13:34:19 GMT

Thanks a lot for your help.
Infact the qvw that I have provided is not realyy suitable. (I never use "Load inline").
My problem is still occuring and is not solevd using TEXT().

Concerned loading script is the following. ID_CHAPITRE_GLOB_CPTE sometimes contains '13' and sometimes '013', which are two really different values.
How may I force Qlikview to consider this code as alphanumeric ?

COMPTE :
SQL SELECT "ANNEE_BUDGET_CPTE",
"CLE_COMPTE",
"CODE_SECTION_CPTE",
"ID_CHAPITRE_CPTE",
"ID_CHAPITRE_GLOB_CPTE",
"ID_CPTE",
NIVEAU,
"SENS_CPTE"
FROM "SIPA_DWH_GF"."V_COMPTE";

CHAP_GLOB_TXT :
LOAD distinct "ID_CHAPITRE_GLOB_CPTE",
TEXT("ID_CHAPITRE_GLOB_CPTE") as ID_CHAPITRE_GLOB_CPTE_TXT
resident COMPTE;

Thanks a lot for your help

Data type changed whil Qlik loading

sparur — Tue, 09 Feb 2010 17:49:21 GMT

Hi,

Try this code:

COMPTE :

LOAD CLE_COMPTE, CODE_SECTION_CPTE, ID_CHAPITRE_CPTE, ID_CPTE, NIVEAU, SENS_CPTE,

Text(ID_CHAPITRE_GLOB_CPTE) AS ID_CHAPITRE_GLOB_CPTE_TXT

;
SQL SELECT "ANNEE_BUDGET_CPTE",
"CLE_COMPTE",
"CODE_SECTION_CPTE",
"ID_CHAPITRE_CPTE",
"ID_CHAPITRE_GLOB_CPTE",
"ID_CPTE",
NIVEAU,
"SENS_CPTE"
FROM "SIPA_DWH_GF"."V_COMPTE";