Qlik Community

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

philgood34
Contributor II

COMPOSED FIELD AS KEY

Hi,

Following my  issue in the post named " SIMPLE" LINK TABLE (19/08) , i applied the script to my real datas

bad news ! the composed field is not recognized ,???


here is the script (I copied only an extract ) with the issue highlighted .. I would like to point out that first i use the automatic loading of QLIK SENSE then i corrected it manually ... i saw that  automatic editor add a " $" at the table's name  . i don't know why, but i think it's not the problem


MAMERS2.png


error.png


Really i don't unterstand the reason ?...


As a reminder, here is a script inspired by Felipe (thank's again) wich works


felipebis.png



have you an idea ?


thank's


i join my test table


Philippe

1 Solution

Accepted Solutions
antoniotiman
Honored Contributor III

Re: COMPOSED FIELD AS KEY

Hi Philippe,

You have 2 Fields named [MOIS_ANNEE] in LOAD

LOAD

VMS_MOI& '_'&VMS_ANN as MOIS_ANNEE,

MOIS_ANNEE,

Regards,

Antonio

4 Replies
antoniotiman
Honored Contributor III

Re: COMPOSED FIELD AS KEY

Hi Philippe,

You have 2 Fields named [MOIS_ANNEE] in LOAD

LOAD

VMS_MOI& '_'&VMS_ANN as MOIS_ANNEE,

MOIS_ANNEE,

Regards,

Antonio

philgood34
Contributor II

Re: COMPOSED FIELD AS KEY

Hi Antonio

obviously ! thank's a lot

i find another mistake with VMS_NCL

what do think about that ?

is it necessary to repeat LOAD 2 times in this case ?

regards

Philippe

antonio.png

antoniotiman
Honored Contributor III

Re: COMPOSED FIELD AS KEY

VMS_NCL is OK.

But You have 2 VMS_ANN.

Remove one of them.

However in Primary LOAD You need only VMS_NCL and MOIS_ANNEE

because You load them in Preceding LOAD.

Regards,

Antonio

philgood34
Contributor II

Re: COMPOSED FIELD AS KEY

understood !

thank's again

regards

Philippe

Community Browser