Other ‣ Examples ‣ Variable Rule

Like the standard rule, the variable rule writes to exactly one target attribute. However, the target attribute can be created dynamically with a tool or a JavaScript instruction.

An example:

Rule editor

  1. the rule in the rule list
  2. in the target attribute, the respective content of color is retrieved, converted to lowercase letters and written to the column created in this way. As color contains two values (RED_CODE/BLUE_CODE), two new columns are created: red_code and blue_code
  3. the content of color is retrieved and written to the current column.
  4. data at the input of the transformation
  5. data after processing in the transformation (preview of the first 10 data records)
  6. the new column red_code.
  7. the new column blue_code.

And another example:

Rule editor

  1. the rule in the rule list
  2. the target attribute is built with the fixed string color_at_ and the tool date(). The target attribute is therefore different every day.
  3. the content of color is retrieved and written to the dynamically built target attribute.
  4. data at the input of the transformation
  5. data after processing in the transformation (preview of the first 10 data records)
  6. the new column color_on_26.07.2024
  7. the unchanged column color

If the transformation runs past midnight, there are two columns :-)