Hey all!
Stuck on something and could use your help. I'm trying to set up a flow, where each time the flow is run, it appends a column of data, based on that current date to a data set.
So using the table below. Imagine I ran it for the first time on 8/1/22. That column is populated by alteryx (pulling the forecast data from another source). Then on 9/1, I run the flow again. It takes the old file as the input file and Alteryx adds a column named "Forecast 9/1/22" and in that column adds the current values for forecast from the data source.
Any idea how to make this work?
| Project Name | Forecast 8/1/22 | Forecast 9/1/22 | Forecast 10/1/22 |
| ABC | 5 | 5 | 10 |
| DEF | 1 | 2 | 3 |
