Drag an ‘Upload’ block onto the worksheet in order to use data from an external file in Ternair Campaign.
The current selection first needs to be saved before you can upload a file. Double click the upload block to show its settings (see the image below):
Files with an .xls, .xlsx, .xlsb, .txt or .csv extension can be uploaded. Select a file by pressing the ‘Upload’ button and browsing to the desired file.
After uploading the file indicate which column in the file contains the key, what kind of key it is (for example accountid or e-mail address). Furthermore indicatie whether or not the file contains a header, Ternair Campaign should use the column (data) types from the upload (Excel files only) and whether the upload is a global upload.
When the upload is saved the file is loaded into Ternair Campaign. In the selection flowchart the upload block shows the number of rows (records) containing a value in the key column.
A successfully uploaded file can be used as source in other selection functions, such as Selection, Split, Sample, Switch or Deduplication. Connect the Upload block with another (selection) function block by dragging an arrow from the Upload block to the selection block.
A ‘global upload’ can be used as source in other selections. Existing global uploads blocks are always read-only.
When the option Use column types from file is selected in an upload block, the column (data) types from the uploaded Excel file are used as field types in Ternair Campaign for these fields.
The following data types are supported:
- other / text
Depending upon the data type the corresponding operators are available for this field. See Selection for further details on selection operators.