topic Re: COMPOSED FIELD AS KEY in Connectivity & Data Prep

COMPOSED FIELD AS KEY

philgood34 — Sun, 20 Aug 2017 09:00:36 GMT

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

Re: COMPOSED FIELD AS KEY

antoniotiman — Sun, 20 Aug 2017 09:07:02 GMT

Hi Philippe,

You have 2 Fields named [MOIS_ANNEE] in LOAD

LOAD

VMS_MOI& '_'&VMS_ANN as MOIS_ANNEE,

MOIS_ANNEE,

Regards,

Antonio

Re: COMPOSED FIELD AS KEY

philgood34 — Sun, 20 Aug 2017 09:33:50 GMT

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

Re: COMPOSED FIELD AS KEY

antoniotiman — Sun, 20 Aug 2017 09:43:46 GMT

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

Re: COMPOSED FIELD AS KEY

philgood34 — Sun, 20 Aug 2017 09:48:43 GMT

understood !

thank's again

regards

Philippe