Update Variable in Script and Trigger a reload

[kwhwan]

Hello,

I am working with a very huge database which often takes hours to load.  It is a database which would append daily records to it so that I can keep track of all the changes and historical data.

Therefore, in the load script I would include a statement in the load script editor like this to shorten the load time:

WHERE vRECORD_DATE = '2021-10-11'

However,  I would also like to make this a variable so that I can change it in the front end.

I am trying to take this approach

Let vRECORD_DATE = today();

However, everytime I update the variable using variable input and reload the data, it is still showing today()'s value.

May I know how to update the variable in the front end and trigger a reload on the sheet as well? (without going to the load script editor)

Thank you so much!

[abhijitnalekar · Accepted solution]

Hi @kwhwan ,

Is there any specific reason for not using the Incremental load?

[kwhwan]

hello, thanks for the reply. I tried incremental load and it worked! Thank you!