Menu

Click on Select Attributes and select the parameter attribute filter type to either subset or regular_expression.

For subset, click on the Select Attributes... button, and add the attributes (columns) of your CSVs that you want to have in your merged output. Add them in the right list of the window by typing the name and clicking the plus icon.

For regular_expression you can define a list of attriutes (columns) like this: .*attribute1.*|.*attribute2.*|.*attribute3.*

example:

.*mail.*|.*date_submitted.*|.*page_url.*

Then you are done.

Merge columns with different names into the same column (attribute):

In case you have columns in your CSV with different naming, like: e-mail, eMail, e_mail you can do the following:

In your existing Select Attributes Object choose regular_expressions. Define a regular_expression that contains all columns you want, and also the variants. If I have the following columns:

• E_mail
• e-Mail
• Mail
• date_submitted
• name

I would create the following regular_expression:

.*mail.*|.*date_submitted.*|.*name.*

This will still create an output with different columns (attribute). To merge the 3 Email columns into one, you have to rename them to be identical. Add a Rename by Replacing Object after the already existing Select Attributes.

On the Rename by Replacing Object select regular_expression as the attribute filter type. Then fill out the fields below like:

regular expression: .*mail.*

replace what: .*

replace by: mail

I attached a gif of my process, to clarify.