Hi All,
I have a output file (.hyper file) which combines Data say as below
Month end of Jan - File Generated 1st of Feb morning (But Data as of 31-01-2023)
Month end of Feb - File Generated 1st of March morning (But Data as of 28-02-2023)
Today File - File Generated 29th April Morning (But Data as of 28-03-2023)
The solution I'm looking for is
Firstly when the WF is run in Alteryx server for tomorrow morning the existing Data which (28-03-2023) should be replaced with Data as of (29-03-2023)
Secondly when the workflow is run in Alteryx server on 1st of April 2023 the output should have the data as below
Month end of Feb
Month end of March
Thirdly when the workflow is run in Alteryx server on 2nd of April 2023 the output should have the data as below
Month end of Feb
Month end of March
Today File - File Generated 2nd April Morning (But Data as of 01-04-2023)
when the WF is run on Daily basis it has to replace the Yesterday's Data with current Data for the month end as well.
Thanks
