Hi All,I have a table(data model) like the below. For every quarter there will be 2 new columns( Status and comments).I tried unpivot the Q3, Q4 status in one table and in the other by Q3, Q4 comments. And merge these two tables but I did get the required table 2. What transformations I need to perform to get table 2.CategorySub CategoryQ3- 2023 statusQ3- 2023 commentsQ4- 2023 status Q4- 2024 commentsOwnerRoadBikeIn progressWorkingIn progressN/ADavidRoadCarIn progressUnder validationCompletedN/ASmithElectronicsPhoneIn progressWorkingCompletedN/AHenryElectronicsLaptopIn progressManufacturingIn progressManufacturingMichealElectronicsHeadphonesIn progressN/ADelayedWorkingNeilClothesShirtIn progressTransportationDelayedReceived on MondayPeterClothesTrousersIn progressTransportationCompletedDoneChris Table 2 - CategorySub categoryQuarterStatusCommentsOwnerRoadBikeQ3-2023In progressWorkingDavidRoadBikeQ4-2023In progressN/ADavidRoadCarQ3-2023In progress Under validationSmithRoadCarQ4-2023CompletedN/ASmithElectronicsPhoneQ3-2023In progressN/AHenryElectronicsPhoneQ4-2023CompletedWorkingHenryElectronicsLaptopQ3-2023In progressManufacturingMichealElectronicsLaptopQ4-2023In progressManufacturingMichealElectronicsHeadphonesQ3-2023In ProgressN/ANeilElectronicsHeadphonesQ4-2023DelayedWorkingNeilThanks in advance

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

Helper III

2 years ago

Solved

Data model - Unpivot

Hi All,

I have a table(data model) like the below. For every quarter there will be 2 new columns( Status and comments).
I tried unpivot the Q3, Q4 status in one table and in the other by Q3, Q4 comments. And merge these two tables but I did get the required table 2. What transformations I need to perform to get table 2.

Category	Sub Category	Q3- 2023 status	Q3- 2023 comments	Q4- 2023 status	Q4- 2024 comments	Owner
Road	Bike	In progress	Working	In progress	N/A	David
Road	Car	In progress	Under validation	Completed	N/A	Smith
Electronics	Phone	In progress	Working	Completed	N/A	Henry
Electronics	Laptop	In progress	Manufacturing	In progress	Manufacturing	Micheal
Electronics	Headphones	In progress	N/A	Delayed	Working	Neil
Clothes	Shirt	In progress	Transportation	Delayed	Received on Monday	Peter
Clothes	Trousers	In progress	Transportation	Completed	Done	Chris

Table 2 -

Category	Sub category	Quarter	Status	Comments	Owner
Road	Bike	Q3-2023	In progress	Working	David
Road	Bike	Q4-2023	In progress	N/A	David
Road	Car	Q3-2023	In progress	Under validation	Smith
Road	Car	Q4-2023	Completed	N/A	Smith
Electronics	Phone	Q3-2023	In progress	N/A	Henry
Electronics	Phone	Q4-2023	Completed	Working	Henry
Electronics	Laptop	Q3-2023	In progress	Manufacturing	Micheal
Electronics	Laptop	Q4-2023	In progress	Manufacturing	Micheal
Electronics	Headphones	Q3-2023	In Progress	N/A	Neil
Electronics	Headphones	Q4-2023	Delayed	Working	Neil

Thanks in advance

Need Help

Show and Tell

Tips and Tricks

Ahmedx
2 years ago
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

370.pbix22 KB

Forum Discussion

Data model - Unpivot

3 Replies

Related content

Data Modeling

Pivot / Unpivot?

Unpivot Column

Unpivot Question

Unpivot