Other ‣ Examples ‣ Standardrule

The standard rule makes a value assignment in exactly one attribute.

Example:

Rule editor

  1. the rule in the list
  2. the target attribute, it is written in farbe.
  3. the value assignment, the content of color is fetched and written to farbe.

Another example:

Rule editor

  1. the rule in the list
  2. the target attribute, it is written in farbe
  3. the value assignment, the content of color is fetched, processed by the tool lowerCaseText and written to farbe.

After clicking on Preview, you can see what has happened in the data view below: Rule editor

  1. data at the input of the transformation
  2. data after processing in the transformation (preview of the first 10 data records)
  3. in the source column color everything is in capital letters
  4. in the preview column farbe you can see what the value assignment has built. The content of color was taken, changed to lower case and stored in the farbe attribute.
  5. the preview column color still contains the original, unchanged content. A new attribute farbe has therefore been created.

And another example:

Rule editor

  1. the rule in the list
  2. the target attribute, it is written in `color
  3. the value assignment, the content of color is fetched, processed by the tool lowerCaseText and written to color.

After clicking on Preview, you can see what has happened in the data view below: Rule editor

  1. data at the input of the transformation
  2. data after processing in the transformation (preview of the first 10 data records)
  3. in the source column color everything is in capital letters
  4. in the preview column color you can see what the value assignment has built. The content of color was taken, changed to lower case and stored in the color attribute. In this case, no new attribute has been created, but an existing one has been changed or overwritten. This means that the original content of color no longer exists.