topic Variables declaration on Script in App Development

Variables declaration on Script

Nuckpio — Tue, 30 Apr 2019 09:06:01 GMT

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.

Re: Variables declaration on Script

johngouws — Tue, 30 Apr 2019 10:07:27 GMT

Just a thought, have you tried setting them in the Load script?

Something like

SET vMax_Date = "=max(Date)";

Re: Variables declaration on Script

Nuckpio — Tue, 30 Apr 2019 12:39:05 GMT

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!