This project is read-only.

Replace

Added in version 1.9

In some cases, you'll want to replace the whole content of a column by another value. To achieve this you'll need to use the action replace and specify the column impacted and the new value of this column.

case replace column 'alpha' with values 'my new value'

Condition to the replacement

If you don't want to replace the content of each row but only of a subset then you'll need to add a condition. A condition is expressed in the same way than the condition for a filter

case replace column 'alpha' with values 'my new value' when values not equal 'foo', empty, 'bar';

Last edited Dec 23, 2014 at 5:51 PM by Seddryck, version 1

Comments

No comments yet.