Discussions

Expand all | Collapse all

Automations turn off after an error

  • 1.  Automations turn off after an error

    Posted 08-15-2018 18:41
    I'm trying to add a value from Table A as a unique primary key into Table B. However, sometimes there are duplicate values in Table A, so I WANT them to error out and not be added to my table. However, the automation automatically shuts itself off after one error. This is really annoying because I still want the automation to continue even if there is an error. 

    For example:
    Table A 
    1:10
    1:11
    1:10

    Table B
    1:10
    1:11

    That is the final structure I'd like. 

    I understand that it doesn't want to run into infinite loops, but that isn't what's happening here. 

    Is there any way to do this with automations, or do I have to write a custom script to populate this table with a loop checking for duplicates? 


  • 2.  RE: Automations turn off after an error

    Posted 08-16-2018 17:33
    Have you considered a table to table import? You can set it up to merge records with the same ID.

    You can then automate the import with an Automation.