Forum Discussion
Table Transformation
Hi cesarwheezer,
Thank you for reaching out to the Microsoft Fabric Forum Community, and a special thanks to the scott2718, BA_Pete and Shubham_rai955 for their prompt and helpful responses.
Could you please provide a bit more information, as suggested by BA_Pete , so we can assist you further?
Best regards,
Prasanna Kumar
Advocate ILooks like you just need to use the Pivot transformation.
Select Field Description as the field to pivot, and then in the aggregation options select Don't Aggregate.
Not quite. I tried the pivot column function. The field values are not listed the way I want it. At the end of thread, I attached a screenshot of exactly what I want to see as the final transformation.
- scott2718
I think your data is not good. I can see that your work order ID = 1 has multiple dates for adjusted forecast. But since the value field is in the same column instead of next to it, you can't guarantee you will select the right pair of values if you try to unpivot it.
Do you have another data source that has dates and dollars in adjacent fields? Or an extra field that provides another ID? Without a way to make each date/dollar pair unique, you probably won't accurately pivot this.
