Extract file

Drag and drop an Extract file activity into your workflow.

Select the activity, then open it using the button from the quick actions that appear.

Enter the label of the Output file. The label of the file will automatically be completed with the date and time it was created so that it is unique. For example: recipients_20150815_081532.txt for a file generated the 15th of August 2015 at 08:15:32.

If you like, you can zip the output file by selecting Compression in the Add a pre-processing step field. The output file will be compressed into a GZIP file (.gz).

Click the or Add an element button to add an output column.

A new window will open.

Enter an expression. To do this, you can select an existing expression or create a new one using the expression editor.

Confirm your expression.

The expression is added to the output columns.

Create as many columns as you need. You can edit columns by clicking their expressions and labels.

If you are exporting profiles and want to use them in an external tool, make sure you export a unique identifier. By default, not all profiles have a unique identifier, depending on the way they are added to the database. For more information, refer to the Generating a unique ID for profiles section.

Click the File structure tab to configure the output, date, and number formats for the file that will be exported.

Check the Export labels instead of internal values of enumerations option in case you export enumeration values. This option allows to retrieve shorter labels that are easy to understand instead of IDs.

In the Properties tab, select the Do not generate a file if the inbound transition is empty option to avoid creating and uploading empty files on SFTP servers if the inbound transition is empty.

Confirm the configuration of your activity and save your workflow.

Drag and drop an Extract file activity into your workflow and place it after the Query activity.

In this example, the query is carried out on all profiles aged 18 to 30.

Open the Extract file activity to edit it.

Name the output file.

Add output columns.

In this example, the email, age, date of birth, first name and last name of the profiles are added as output columns.

Click the File structure tab to define:

Confirm your activity.

Drag and drop a Transfer file activity after the Extract file activity to recover the extract file on an external account.

Open the activity and choose the File upload action.

Select the external account and enter the path of the folder on the server.

Confirm your activity and save your workflow.

Start the workflow.

When the workflow has been executed correctly, the extracted file is available on the external account.