07-30-2015 09:31 AM
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.
07-30-2015 10:37 AM
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 .