Azure Data Factory - ADF pipeline to increment the date back to six months RRS feed

  • Question

  • Hi,

    i have folders created on each day [20201114], so there are 12 months folders created based on date.
    i want my pipeline to copy the files from each folders ; Starting from current date [20201114] till 6 months back folders data [20200514]

    i have created two variables start date [@formatDateTime(AddToTime(utcnow(), -6, 'Month'), 'yyyy-MM-dd')] and end date [@formatDateTime((utcnow(), 'yyyy-MM-dd')]

    now how to increment dates one by one from start to end date

    Now i want the copy activity to increment 1 + day to this variable and copy the data from respective date folder

    for eample: varibale output is [2020-05-14] >> adding +1 [2020-05-14 + 1] = [2020-05-15]>> copy activity should search for the folder name [2020-05-15] and process

    like wise the process should continue from [2020-05-14] till [2020-11-14]

    how to achieve this through ADF Pipeline

    Sunday, November 15, 2020 3:01 PM

All replies

  • azure related forum migrate to mentioned below link please use this

    hope answer the question if issue resolve please mark as answer

    Sunday, November 15, 2020 4:56 PM