Remove rows if a column contains a specific value.

justcotto — Tue, 19 Feb 2019 15:51:04 GMT

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

Re: Remove rows if a column contains a specific value.

pradosh_thakur — Tue, 19 Feb 2019 16:02:55 GMT

load  ......... ,

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


from table_name

where not match(column1,'value1',' value2 ','value3');

topic Re: Remove rows if a column contains a specific value. in QlikView

Remove rows if a column contains a specific value.

Re: Remove rows if a column contains a specific value.