โ08-20-2024 09:55 AM
Is there way to add entry to lookup table only if doesn't already exist (based on a specific column value?)
Came across a recipe which seems to be inefficient - it's looking a search for the value in lookup table, monitoring for error (entry not found error) and then adding/inserting.
Solved! Go to Solution.
โ08-20-2024 09:59 AM
This should be possible. If you're receiving an error when the value is missing, you can use an error handler action to create the lookup table entry and then retry the action.
โ08-20-2024 09:59 AM
This should be possible. If you're receiving an error when the value is missing, you can use an error handler action to create the lookup table entry and then retry the action.
โ08-20-2024 10:06 AM
That's exactly what is done, but I hoping for better way - for now what you described works. Thanks!!
โ08-20-2024 10:33 AM
Just curious, what would you consider a better way?
โ08-21-2024 05:46 AM
Maybe if it had an Upsert action?