Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello I'm having trouble with filtering out some data.
I have a table with about 10 different columns.
I need to find a solution where I remove fields in columns w,x,y,z when they have the value 'None'
Hi @kfloresc , you can start with this as an option :
Load
w,x,y,z
morefields
From yoursource
Where
w <> 'None' and
x <> 'None' and
y <> 'None' and
z <> 'None';
Thank you Fabian! That was the answer, for some reason I couldn’t do it in the select area and had to do it under the load section! Again thank you so much!
Hi @kfloresc , you can start with this as an option :
Load
w,x,y,z
morefields
From yoursource
Where
w <> 'None' and
x <> 'None' and
y <> 'None' and
z <> 'None';
Thank you Fabian! That was the answer, for some reason I couldn’t do it in the select area and had to do it under the load section! Again thank you so much!
Excelent @kfloresc , all of that is in the script, or load section.
Please give like or aproved as solution