[How to concatenate two list variables]

You can do that simply using the function cat().

If you want to use a list composed by @var1 and @var2 in your Fill & Clean task, you have to write in your parametric option the following line:

cat(@var1,@var2)

Generally speaking, cat() function allows you to concatenate 2 lists only.
If you want to concatenate three or more (e.g. @var1, @var2 and [“A”,“B”,“C”]) you have to write:

cat(cat(@var1,@var2),[“A”,“B”,“C”])

 

[Keeping a set of attributes depending on a variable]

Hi,
define two code variables att1 and att2, both containing a list of your attributes in the format:

[“var1”, “var2”, …, “varN”]

Open the Fill & Clean task, click on the “f(x)” button to open the parametric option panel of “Available attributes”, fill the parametric option as shown in the following picture:

[Concatenate data managers with different column name]

Hi!

The solution is to use a positional concat. First you have to make sure that the columns are ordered the same way in the two datasets. Then you link the two datamanagers to a concat. Open the concat task: in the "options" menu, select concatenation by position