Classic file types are no longer available for use as of January 2021. You can transition your classic files or download a PDF. Learn More

Create File error: 'duplicate file name'

Answered

Comments

2 comments

  • Official comment
    Tony Scalese

    Hi Lina,

    You've got two different things going on here.  First, Wdata requires that a file name is unique.  To account for this, you can build the Chain to unimport and delete the file before importing the new file.  We have a Template that shows how this is done:

    https://support.workiva.com/hc/en-us/articles/360058919852-Update-Datasets-in-a-Table-chain-template

    The second problem is that the Runtime Variable Chain.RunDateTime returns a date time stamp in ISO format including a colon for the hours & minutes separator.  Since a colon is an invalid character in a file name, you need to use Variable Transformation to modify the file name to be compliant:

    https://support.workiva.com/hc/en-us/articles/360035643752-Transform-variables-and-outputs

    I would strongly recommend that you familiarize yourself with the Chain Template though because failure to delete the file will cause duplicate data if you are loading an updated dataset for essentially the same data.

    Hope that helps.

    Tony

  • Lina Zhao

    Thank you very much Tony for pointing me in the right direction! I will definitely get familiar with the update-datasets chain as I can see bad consequences down the road happening without setting this properly...

    Lina 

    0

Please sign in to leave a comment.