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

Update Datasets in a table chain template not working

Answered

Comments

6 comments

  • Tony Scalese

    Hi Lina,

    I would look at the execution on each run, specifically the Create File Command.  Look at the Inputs tab and see what the file Name is.  Then compare that against the last run.  If the file name isn't the same, that's why the import is adding duplicative rows.  Also check in the Update Table Sets Chain to see if the unimport and delete happened successfully.  

    Tony

    0
  • Tony Scalese

    Another thing, I am not sure why you have Create File and Import File in the parent level Chain.  These actions are being done in the child Chain.  I believe you can remove these.  

    0
  • Lina Zhao

    Hmm, I see where (part of) my problem was Tony, the 'Create File' and 'Import File' commands are already part of the template/child chain, I don't need them again in the parent chain anymore. So I removed them and the chain now looks like this: 

    However, the table is still not replaced properly, it sometimes updates the records (i.e. adds NEW records to the table), sometimes replaces part of the old records but not all of them. I also compared the file Name in the Create File Command (Input Tab) from different runs, and the file names are different. Unimport and delete commands were successful. Is there anything else I can do? Thanks!

     

    Lina 

    0
  • Tony Scalese

    I would need screenshots of the Log tab on the Commands you highlighted to comment further.  

    0
  • Lina Zhao

    Hey Tony, so I tested plenty of times more, but it seems that the chain is working properly now, i.e. old records are completely replaced with new records, not sure what were the issues before, but I'm glad they are fixed now.

    Thanks for all help!

    Lina

    0
  • Tony Scalese

    Thumbs up!  Glad it's working.  

    0

Please sign in to leave a comment.