How to extract headers from a file in Alli SFTP
Overview
A file’s headers define the data schema for a list. In order to import data into Alli Audiences, the list’s columns need to be defined (by title and data type). Unfortunately clients don’t always share the headers for their files, which can make the setup of a new audience list an arduous job. However, by following this document you’ll be able to extract the headers information from a file without compromising data security!
Instructions
Go to https://app.alliplatform.com/client/{client_slug}/cloud-storage
Click on the file you want to view to preview the file
Your file’s headers will appear under “Headers”, separated by a comma.
If the file doesn’t contain Personal Indentifiable Information, a preview of the data will be displayed on the “Content” section.
Examples:
Alli SFTP can infer the data type from files without columns. In the case of a file not containing a headers row, the code will infer the data type and display it in between asterisks (e.g. **********EMAIL**********
).
Related articles
- How to enable Big Query for a custom alert
- How to name Datasource Columns
- How to manually upload data to an existing datasource
- How to archive and unarchive data sources
- How to create a manual datasource without validations
- How to setup a datasource that requires custom data
- How to Create a new datasource
- How to update datasource dimensions and metrics
- How to create a Smartsheet Datasource
- How to add a manual upload datasource