How to set a fixed schema for a certain file upload when rescanned?

2 followers
1
Avatar

I have some file uploads linking to workbooks where the files are replaced monthly.

In the configuration step, I do a rescan of the schema to update the rows but then I lose all of the data types that I've defined previously. 

Is there a way to keep the schema (using metadata or something) for the particular columns while updating the underlying data? 

Should I be using import jobs or data links instead of file uploads?

Jooha Kim

1 comment

  • Avatar
    Alan Mark

    Hi Jooha,

    Unfortunately there is not a way to retain the old schema automatically.  However, you can create a custom schema file to use when you rescan.

    See the Custom Headers section of our Importing Data document.

    The file should be a strictly quoted CSV with the first row being the column names, and the second row being representative of the data type.  

    On the Data Details step you will change the Schema radio button from Auto-detect to Provide custom schema.

    Supply your header file, and then click the File contains data checkbox.

    Let me know if you have any questions - but I think this should help streamline this workflow!

    0
Please sign in to leave a comment.