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.
I have a table with four columns, some of the rows are entirely blank but I want to remove only those rows where every column is null. How do I do this?
Solved! Go to Solution.
Hi,
you can just use the remove blank rows option.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Hi,
you can just use the remove blank rows option.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
To remove only the rows where every column is null, you can use the following SQL query:
DELETE FROM your_table
WHERE column1 IS NULL
AND column2 IS NULL
AND column3 IS NULL
AND column4 IS NULL
This query will delete all rows where every column is null. If a row has at least one non-null value in any of the columns, it will not be deleted.
Alternatively, if you want to keep the original table intact and just display the rows with non-null values, you can use the following SQL query:
SELECT * FROM your_table
WHERE NOT (column1 IS NULL
AND column2 IS NULL
AND column3 IS NULL
AND column4 IS NULL)
This query will select all rows where at least one column has a non-null value. The NOT operator negates the condition that every column is null, so only rows that satisfy this condition will be displayed.
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 |
---|---|
84 | |
83 | |
64 | |
61 | |
55 |
User | Count |
---|---|
171 | |
109 | |
109 | |
73 | |
71 |