When uploading data via the data library 'Smart Upload' is the most flexible option - the order or format of the columns does not matter as it does with other import options.
Smart Upload allows users to easily upload any spreadsheet file into the platform, regardless of how it is formatted and save custom upload templates to reuse for quick uploads in the future .
Smart Upload can currently only be used when uploading data via the Data Library.
Before using Smart Upload
Prior to using Smart Upload, please ensure:
The file is saved in .csv or .xlsx format
All populated columns in the file have been labelled with a header
If there is a large number of columns in the spreadsheet, remove any that are not relevant before uploading in order to ensure an efficient upload
Selecting Smart Upload
Navigate to Data Library. and click the cloud icon to upload your data.
Select 'Smart Upload' from the pop-up window and click 'Browse files' to choose your data set
Check any desired cleaning options and click 'Next'
The platform automatically identifies which columns contain dates, text and metadata (a set of information that describes your data, such as age, location or gender).
Ensure to verify that the columns have been correctly classified, and if necessary, drag and drop column headings to reclassify or move to the bin.
If multiple date values are present in the dataset, use the radio buttons to specify which column should be treated as the date for purposes of time series analysis.
Once this is done, click 'Submit' to complete the upload.
Saving custom upload templates
Saving your smart upload settings enables you and others on your team to upload data and apply the same settings to similar files in one click.
When reviewing the settings, click the checkbox at the bottom of the screen to Save as an upload setting then click 'Submit' (as seen above).
Name your settings file and optionally add a description or link to a logo file then click 'Save.'
To use your saved settings on a new file, select 'Custom' when prompted to select a data source then choose the relevant settings.
If the column headers in your data file change (the order doesn't matter), simply run the new version through Smart Upload, save your new template and start using it.