I have a simple process where I upload two files each week, merge them, then create an Excel export.
Every ingest, there are two values for Interval, representing weeks.
| Demographic | Interval | Originator | Program Name | Telecast Count | Total Duration | MC US AA Proj (units) |
| Persons 2 - 99 | 12/11/2023 - 12/17/2023 | Platform A | Program A | 11 | 846 | 10,000,000 |
| Persons 2 - 99 | 12/11/2023 - 12/17/2023 | Platform B | Program B | 12 | 273 | 10,000,000 |
| Persons 2 - 99 | 12/11/2023 - 12/17/2023 | Platform B | Program C | 1 | 56 | 10,000,000 |
| Persons 2 - 99 | 12/11/2023 - 12/17/2023 | Platform C | Program D | 1 | 55 | 10,000,000 |
| Persons 2 - 99 | 12/11/2023 - 12/17/2023 | Platform C | Program E | 1 | 55 | 10,000,000 |
| Persons 2 - 99 | 12/18/2023 - 12/24/2023 | Platform A | Program A | 11 | 846 | 15,000,000 |
| Persons 2 - 99 | 12/18/2023 - 12/24/2023 | Platform B | Program B | 12 | 273 | 15,000,000 |
| Persons 2 - 99 | 12/18/2023 - 12/24/2023 | Platform B | Program C | 1 | 56 | 15,000,000 |
| Persons 2 - 99 | 12/18/2023 - 12/24/2023 | Platform C | Program D | 1 | 55 | 15,000,000 |
| Persons 2 - 99 | 12/18/2023 - 12/24/2023 | Platform C | Program E | 1 | 55 | 15,000,000 |
The stakeholder would like the two intervals to appear as columns in the Excel output, with values for various metrics side by side, like so:
| | | MC US AA Proj (units) | MC US AA Proj (units) | Telecast Count | Telecast Count |
| Originator | Program Name | 12/11/2023 - 12/17/2023 | 12/18/2023 - 12/24/2023 | 12/11/2023 - 12/17/2023 | 12/18/2023 - 12/24/2023 |
| Platform A | Program A | 10,000,000 | 15,000,000 | 11 | 11 |
| Platform B | Program B | 10,000,000 | 15,000,000 | 12 | 12 |
| Platform B | Program C | 10,000,000 | 15,000,000 | 1 | 1 |
| Platform C | Program D | 10,000,000 | 15,000,000 | 1 | 1 |
| Platform C | Program E | 10,000,000 | 15,000,000 | 1 | 1 |
In general, I believe I have achieved this via the crosstab function in the attached workflow. However, the challenge arises when the string value for the intervals change, which they will do with each ingest. Because my new crosstab columns are named for the week in question, the workflow doesn't update dynamically - the old intervals are kept as an artifact with each new data import. For example, when I import data for the weeks of Jan 1 and Jan 8, I'd like my crosstab headers to adjust too - with the current solution - I'm left with remnant columns for Dec 11 and Dec 18
Is there a way that I can update my Interval columns update dynamically with the string value[s] being imported each week without any manual intervention?
I am fairly new to Alteryx, so am open to more optimal solutions for achieving the desired crosstab view!
