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 date I specify.

 

I have dozens of queries to append and all relate to specific dates. I dont wish to have to come in and do each of the manually across the year.  So how would I get the following to only append after June 1st 2022 ?

 

#"Appended Query" = Table.Combine({#"Table2", #"Table1"})

 

Thanks in advance

Need Help

2 Replies

  • 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.