Add the file name where the data comes from in a column of the dataset?

Problem Description:

How can I add the file name where the data comes from in a column of the dataset?

Solution:

Fill in the Additional Tracking Column field in the source configuration screen:

Enter the desired name for the new column, for example: “foo”:

Once done, there is a new column foo:

Next, there are several ways to process the foo column in the preparation editor. Suppose, for example, that you need to remove the prefix “My Workspace/”

Choose the following transformation:

In the table (see figure below)

Click once in a cell (to give it focus) then drag (left button pressed) the mouse to select the text “My Workspace/”

Select the option that interests you in the table below. Here Text between positions 1 (inclusive) and 23 (exclusive)

Select the Delete option in the combo box (since we want to remove the suffix).

Click, as usual in the preparation editor, on the red Apply button

Result: