pick(match)

[krish2459]

Hi,

I'm trying to write below condition

pick(match(MvT, '711','712','713'),'711','712','713')

but I'm getting out as 

711 and 712

713 is missing.

Help me to get this.

Thanks..

[nevilledhamsiri · Accepted solution]

Try This out,

pick(match(MvT, '711','712','713') +1,   'No', 'Yes') As mvt_flag

This way, Yes will carry the said numbers .

[sunny_talwar]

What exactly is the use of Pick Match here? MvT and the new field created will always be the same, right? because 711 is mapped to 711, 712 is mapped to 712 and 713 to 713