Automations turn off after an error

  • 0
  • 2
  • Question
  • Updated 11 months ago
  • In Progress
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? 
Photo of Kate Theriault

Kate Theriault

  • 362 Points 250 badge 2x thumb

Posted 11 months ago

  • 0
  • 2
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.