COMPOSED FIELD AS KEY

[philgood34]

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

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

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

have you an idea ?

thank's

i join my test table

Philippe

[antoniotiman · Accepted solution]

Hi Philippe,

You have 2 Fields named [MOIS_ANNEE] in LOAD

LOAD

VMS_MOI& '_'&VMS_ANN as MOIS_ANNEE,

MOIS_ANNEE,

Regards,

Antonio

[philgood34]

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

[antoniotiman]

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]

understood !

thank's again

regards

Philippe