Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Philippe,
You have 2 Fields named [MOIS_ANNEE] in LOAD
LOAD
VMS_MOI& '_'&VMS_ANN as MOIS_ANNEE,
MOIS_ANNEE,
Regards,
Antonio
Hi Philippe,
You have 2 Fields named [MOIS_ANNEE] in LOAD
LOAD
VMS_MOI& '_'&VMS_ANN as MOIS_ANNEE,
MOIS_ANNEE,
Regards,
Antonio
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
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
understood !
thank's again
regards
Philippe