cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Lookup Table add entry if doesn't exist

deepaks
Deputy Chef II
Deputy Chef II

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. 

1 ACCEPTED SOLUTION

gary1
Executive Chef III
Executive Chef III

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.

View solution in original post

4 REPLIES 4

gary1
Executive Chef III
Executive Chef III

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.

deepaks
Deputy Chef II
Deputy Chef II

That's exactly what is done, but I hoping for better way - for now what you described works. Thanks!!

gary1
Executive Chef III
Executive Chef III

Just curious, what would you consider a better way?

mppowe
Executive Chef I
Executive Chef I

Maybe if it had an Upsert action?