Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi
I have a table that looks something like this:
I wanted to have one long list of all the subtypes, ideally keeping them with the correct date and ID's.
Using some other posts from here I tried unpivoting but it doesn't seem to have worked instead just giving me each subtype for every ID, where this wouldn't be the case.
Solved! Go to Solution.
Hi @MatH ,
You will have to follow the below steps :
1) Unpivot by selection only the columns - Reason Type 1, Reason Type 2, Reason Type 3, Reason Type 4. It will give you the below result
2) Filter ou the Blank rows from the column -"Value" to get the below table
Hope this helps.
Please accept the solution if this answers your query.
Thanks!
Avantika
Hi @MatH ,
You will have to follow the below steps :
1) Unpivot by selection only the columns - Reason Type 1, Reason Type 2, Reason Type 3, Reason Type 4. It will give you the below result
2) Filter ou the Blank rows from the column -"Value" to get the below table
Hope this helps.
Please accept the solution if this answers your query.
Thanks!
Avantika
Thank you - this is effectively what I had tried but missed the simple last step of filtering out those blanks. Much appreciated
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
83 | |
66 | |
60 | |
58 |
User | Count |
---|---|
194 | |
111 | |
105 | |
79 | |
71 |