SnapLogic - Integration Nation

krupalibshah · ‎02-16-2018

I am trying to use ‘in’ clause in a mapper snap. But it does not evaluate correctly.

30 in [30,40,50] ----> false

30 in [‘30’,‘4’,‘50’] ----> false

(x => x in [‘4’,‘5’,‘6’])(4) ----> false

Has anyone tried it already? Am I missing anything?

roi6rieK · ‎02-21-2018

Syntax for checking if a value is in an array is the same as in javascript.

Try:

[30,40,50].indexOf(30) != -1 —> true

[30,40,50].indexOf(90) != -1 —> false

The reason for the “!= -1” is that indexOf returns -1 if the element is not found in an array. Otherwise it returns the index.

Same method works for strings.

krupalibshah · ‎02-21-2018

Thanks, got it working 🙂

Using 'in' clause in a mapper