Forum Discussion

shaunwilks's avatar
shaunwilks
Icon for Helper V rankHelper V
4 years ago

Conditional Append

I dont want to append a query until a certain point in time this year.   I'd like the append in the advanced script to have a conditon only to append if the current date and time was greater than a...
Need Help
Vijay_A_Verma's avatar
Vijay_A_Verma
Icon for Most Valuable Professional rankMost Valuable Professional
4 years ago

I would like to see your date column. Will your date column contain all dates as 1-Jun-22 or say 1-Jan-22 to 31-Dec-22 and we need to merge only those rows where if today>date specified by you say 1-Mar-22.

shaunwilks's avatar
shaunwilks
Icon for Helper V rankHelper V
4 years ago

There is no date column in the tables. The date I am talking about is the system/coimputer date 

 

I want to append a query after 01/03/2022

I want to append another query after 01/04/2022

I want to append a third query after 01/05/2022

etc etc etc etc 

 

These are web queries where I know the webpages will be populated in the manner I need them too after those dates.

 

At the moment the queries dont have the data I want so I cannot append them now.

 

Rather than have to get into the solution every month I want to schedule the appends and let the online Scheduled Refresh append the queries on the schedule that I set out.