Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
philgood34
Creator II
Creator 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
Master III
Master III

Hi Philippe,

You have 2 Fields named [MOIS_ANNEE] in LOAD

LOAD

VMS_MOI& '_'&VMS_ANN as MOIS_ANNEE,

MOIS_ANNEE,

Regards,

Antonio

View solution in original post

4 Replies
antoniotiman
Master III
Master III

Hi Philippe,

You have 2 Fields named [MOIS_ANNEE] in LOAD

LOAD

VMS_MOI& '_'&VMS_ANN as MOIS_ANNEE,

MOIS_ANNEE,

Regards,

Antonio

philgood34
Creator II
Creator II
Author

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
Master III
Master III

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
Creator II
Creator II
Author

understood !

thank's again

regards

Philippe