Forum Discussion
Replacing Monthly File with next 12 months creates new header names each month
I have a forecast file that I connect to my data model and its very simple: SKU | Channel | M1 | M2 | M3 |...| M12 | But I have the actual MM/DD/YYYY as the column headers so each month, M1-M12 c...
This sounds pretty good. So the selections are the only column headers that it looks at?
BA_Pete
Super User
Super User
Correct. The selected columns are the only ones that get hardcoded, the rest get unpivoted as required.
Pete