Dear Experts,
I have attached the excel output from Alteryx for the Month of Jan-2021 and I have created the columns from Jan-2021 to Dec 2021,
If I run the workflow for the month of Feb 2021, The month-year field auto-capture the month and year for Feb 2021 based on the date formula which I have created already in the workflow, however, I want to move the data from the value column to Feb 2021 column. Likewise every month I run the workflow the value numbers should move or copied to the respective month.
Sample excel spreadsheet attached, please provide the solution in the workflow
Hi @STAR1BANU
I would transpose the data and then update the values based on if the month-year field is equal to the column header. This assumes the column headers line up with whatever your date formula is doing. Hopefully this gives you some idea as a starting point