SQL Server Execute - Dealing With No Results
Dear Snaplogic Community
I am calling an SQL Server Execute to return the field value of “CLI_SUR_NM” i.e. surname in the table based on a “$FinalIngenPolicyNo” primary key fed by a mapper. If the ...
Forum Discussion
Since your conditions are simple string comparisons, I would suggest using an Object Literal to store the values for each key and then using the get() method to do the lookup:
{
objs: {
OBJ1: 'OBJ2',
OBJ3: 'OBJ4',
OBJ5: 'OBJ6',
OBJ7: 'OBJ8',
},
FindObjectID: x => this.objs.get(x, 'UNKNOWN')
}In your first post, the screenshot shows the Execute snap not generating any preview documents. But, you don’t have ‘Execute during preview’ checked for the snap, so it won’t running during validation/preview. Can you select that and try again?
