Click on the File Import tile. You can find it using the search or checking the Flat Data category.
File Importing flow will be opened after accessing the corresponding datasource.
Step 1 - Import
Click to select a file from your computer, or simply drag and drop your file to this area.
{%docs-informer info title="Note"%} A file must begin with column headers starting in column A. {%docs-informer-end%}
After picking the file a processing bar will show the upload progress. You can click on the “trash bin” icon to cancel the file upload.
After your file has been successfully uploaded and checked for security let’s move to the settings.
~The first line of the file must be a column’s title. If additional information is provided before the column titles — it is necessary, use the Header rows to skip field to skip a certain number of rows to import data correctly.
Click on the Continue button.
Step 2 - Match
Set the Table name which will be used for loading data to your destination.
Select the columns you need to import. By default, all columns are selected.
Check the type. Each column in a data table can be assigned a text, number, or date type.
~The date column is a unique date-key in the database and should be singular.
~If you have column with numeric values that you don't want to include in your calculations, change the type from Number to Text.
The skip rule allows you to exclude rows with specific values in a selected column.
~For example, you can use it to keep certain campaigns in the spreadsheet but skip them during extraction based on their campaign name. You can also use it to exclude rows with total values.
~Please note that regular expressions or rules such as '<10' are not supported."
{%docs-informer info title="Note"%} System default account ID, account name, and date_yyyymmdd columns are automatically added by default. The 'id', 'metrics', 'account_id' reserved for internal usage. Please do not import columns with the same names to avoid data issues. {%docs-informer-end%}
Click on the Import N columns button to continue.
Step 3 - Preview
Check the structure of data that will be extracted.
Once you've reviewed the columns, click the Continue button to confirm settings and proceed with data extraction.
How upload more files with the same structure
Find the FileImport on the Connections page.
Choose one of the Imported Files. Each element in the list corresponds to a Data Tabe with a structure set during the first setup.
Click to select a file from your computer, or simply drag&drop an additional file to this area.
A list of uploaded files below will be enriched with a new file.