Hello,
I'm very new to alteryx.
I am downloading a cvs file with data that I need formatted into an existing excel report. The viewers prefer seeing the data laid out horizontally for multiple months "month over month" -- so the headers look like below
| July | August | Sept
Project ID | Start% | End% | Date | Start% | End% | Date | Start% | End% | Date
The data I download is the latest months Projects Start%, End% and date with the Project ID being the unique id for each. The report has a lot of formatting that needs to be preserved.
Is it possible to append the new data to the report using the project ID to map the data to proper row for the project ID? Ideally I would want it to append the columns of data to the first blank column then map from there.
Thanks!
