Desktop productivity for business analysts and programmers

How to delete the Rows which are not required

Reply
Occasional Contributor
Posts: 15

How to delete the Rows which are not required

Hi, If i have 3 columns like material, quantity and week. Now I have to create a new column in which i do not require the data for which quantity is not available. How to to that? Kindly let me know . Also as i am not using coding so i would appreciate if you can help me in creating this in advance expression in the commutated columns of query builder.

Thanks

Sanchit

Grand Advisor
Posts: 17,428

Re: How to delete the Rows which are not required

I think you need to explain a bit more. If you actually want to remove these rows then it's easiest to add a filter which would be a WHERE clause, otherwise you can try with a CASE function. The CASE function will not delete rows.

Case when quantity ne . then 0

when quantity eq . then .

end

Occasional Contributor
Posts: 15

Re: How to delete the Rows which are not required

Hey thanks a lot...filter make it working which i needed..

Ask a Question
Discussion stats
  • 2 replies
  • 296 views
  • 3 likes
  • 2 in conversation