Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kfloresc
Contributor II
Contributor II

Remove fields where multiple columns strings are the same

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'

 

 

Labels (5)
2 Solutions

Accepted Solutions
QFabian
Specialist III
Specialist III

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

 

QFabian

View solution in original post

kfloresc
Contributor II
Contributor II
Author

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!

View solution in original post

3 Replies
QFabian
Specialist III
Specialist III

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

 

QFabian
kfloresc
Contributor II
Contributor II
Author

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
Specialist III
Specialist III

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

Please give like or aproved as solution

QFabian