Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
load ......... , if(column1='value4','value5',column1) as column1 from table_name where not match(column1,'value1',' value2 ','value3');
load ......... , if(column1='value4','value5',column1) as column1 from table_name where not match(column1,'value1',' value2 ','value3');