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