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: 
justcotto
Contributor III
Contributor III

Remove rows if a column contains a specific value.

Hello,

I have a table that I want to remove rows that contain any of these 3 values (value1, value2 and value3) in a particular column  (column1) and then store all other data in my qvd.

I also would like to replace every instance of a value (value4) in that same column (column 1) and replace it with another value (value5).

Thank you

1 Solution

Accepted Solutions
pradosh_thakur
Master II
Master II

load  ......... ,

  if(column1='value4','value5',column1) as column1


from table_name

where not match(column1,'value1',' value2 ','value3');
Learning never stops.

View solution in original post

1 Reply
pradosh_thakur
Master II
Master II

load  ......... ,

  if(column1='value4','value5',column1) as column1


from table_name

where not match(column1,'value1',' value2 ','value3');
Learning never stops.