Create a column with the value of a variable at the time of the flow execution

Problem Description:

• I have a data table, the “dataset”.

• I have another table with only one row and one column: the “variable”.

I want to create an additional column in the dataset that contains the value of the variable at the time of the flow execution.

What is the easiest way to do this with Tale of Data?

Solution:

The simplest method is:

1. To add a column with a preparation editor, default value “A” for example.

2. To do an enrichment, and match A with the column of a table that contains A, the variable to add.

3. If necessary, delete the column A with a filter node.