Force the "no answer " with an applymap function

[alex59800]

Hello

Just a question on applymap functionnality :

When you do

applymaptest:

MAPPING LOAD

X

Y

SQL SELECT X Y.....

applymap('applymaptest', X)

when applymap does not suceed in finding X, the function give you the answer X.

My question is, can we force the no answer by giving to the no answer by default Z as no answer instaed of X ?

Thanks a lot

Alex

[Anonymous · Accepted solution]

Yes,

applymap('mapname', expr [ , defaultexpr ] )

Just add a default value after X:

applymap('applymaptest', X, Z)

[alex59800]

Thanks a lot Johannes, you're the one !

Best regards