Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
umaluagr
New Member

Delete the rows if the value in one column is null

‎04-16-2024 04:18 AM

Hi community

 

I have a table with 20 columns. If the value in column 5 is null I want to delete this row automatically. The table is constantly filled and I want to avoid having those incorrect rows in there. So, IF column 5 IS null THEN delete row. I am sure there is an easy solution out there. I just don't get it.

Labels:
Message 1 of 4
236 Views
0
1 ACCEPTED SOLUTION
dufoq3
Super User
Super User

‎04-16-2024 04:23 AM

Hi @umaluagr,

yes, there is 🙂 Just filter out null value for [Column5]

dufoq3_0-1713266576146.png

 


Note: Check this link to learn how to use my query.
Check this link if you don't know how to provide sample data.

View solution in original post

Message 2 of 4
229 Views
3 REPLIES 3
dufoq3
Super User
Super User

‎04-16-2024 04:23 AM

Hi @umaluagr,

yes, there is 🙂 Just filter out null value for [Column5]

dufoq3_0-1713266576146.png

 


Note: Check this link to learn how to use my query.
Check this link if you don't know how to provide sample data.

Message 2 of 4
230 Views
umaluagr
New Member
In response to dufoq3

‎04-16-2024 04:25 AM

Thank you for the quick help. I was thinking far too difficult. 

Message 3 of 4
226 Views
0
dufoq3
Super User
Super User
In response to umaluagr

‎04-16-2024 04:36 AM

You're welcome.


Note: Check this link to learn how to use my query.
Check this link if you don't know how to provide sample data.

Message 4 of 4
218 Views
0

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

August Carousel

Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

View All
Top Solution Authors
View All
Top Kudoed Authors
View All