Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everybody .
I tried to declare and define 3 variables inside data load script. The thing is, they are all declared the same way and i obtain different results. (I declared it in the variable panel)
When i go to the variables panel inside the sheet edition, i have only one of them considered as script declared. The two others are empty and not even recognize as script declared (screenshots).
I tried a lot of experimental solutions but non of them worked :')...
is there anyone who knows why my variable doesn't appear as script declared ?
Please, excuse my english skills.
Thank you for your help.
Just a thought, have you tried setting them in the Load script?
Something like
SET vMax_Date = "=max(Date)";
I just found my mistake ! there was an error on my definition and the variable were not interpreted by the load script.
when you concatenate strings with numeric value you need to add parentheses. That was my mistake.
Thank you for your help!