Remove fields where multiple columns strings are the same

[kfloresc]

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'

[QFabian · Accepted solution]

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';

[kfloresc · Accepted solution]

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!

[QFabian]

Excelent @kfloresc , all of that is in the script, or load section.

Please give like or aproved as solution