powered by CADENAS


Manual Concatenated variables

The variables ABC, PQR and XYZ have been concatenated in a variable CONC.

Initial values:

ABC = ‘A’, ‘B’, ‘C’ PQR = ‘P’, ‘Q’, ‘R’ XYZ = ‘X’, ‘Y’, ‘Z’

Changed values:

CONC = ‘$ABC. 0 $PQR.$XYZ.’, Example: CONC = A 0 QY

  1. Open the upper dialog area, so that you can see the target variables. The program already recognized that the variables ABC, PQR and XYZ do not exist anymore in the new version.

    Algorithm for Variable assignment

    Algorithm for Variable assignment

  2. By clicking on Add variable mapping, create a new target variable CONC.

  3. In the right column Variable assignment, click on Algorithm....

    -> The dialog box Edit algorithm is opened.

  4. Enter following algorithm and confirm with OK.

    CONC = ABC//'0'//PQR//XYZ

    Explanations on syntax can be found under Section, “Mathematical functions (Attribute algorithm) ”.

  5. Now when setting new values for ABC, PQR and XYZ in the left table, in the right table under CONC, the desired adjustment is automatically performed.

    Value for "CONC" is automatically detected correctly.

    Value for "CONC" is automatically detected correctly.

  6. Finally click on Verify all mappings .