Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hi @kwhwan ,
Is there any specific reason for not using the Incremental load?
Hi @kwhwan ,
Is there any specific reason for not using the Incremental load?
hello, thanks for the reply. I tried incremental load and it worked! Thank you!