Using list of values in Filter snap

[darshthakkar]

Hi Team,

Is it possible to function a list of values in the filter snap?
Let’s assume, I want to filter IDs whose values are 100, 110, 300, etc., how can I put this in Filter snap without using || function?

I was planning to use $ID IN (100, 110, 300, etc.) but this one doesn’t seem to work so I have been using a conventional way as below:
$ID == "100" || $ID =="110" || $ID =="300"

Thanking in advance for your suggestions.

Regards,
Darsh

[siwadon · Accepted solution]

It depends. If your $ID are numbers, you can change the expression to

[100, 110, 300].indexOf($ID) != -1

I don’t understand your last question about Mapper. Since you mentioned using the Filter snap, this is for the Filter expression setting.

[Abhishek_Soni37 · Accepted solution]

Hi @darshthakkar ,

I used the dummy data below to create a working solution.
Input: 

[
    {"txt":"abc"},
    {"txt":"efg"},
    {"txt":"c - abc"},
    {"txt":"c - xyz"}
]

In the pipeline properties, I've defined a parameter filterValues that will contain the strings based on which you want to filter the records.

Use the below expression in the filter snap:

JSON.parse(_filterValues).map(x => $txt.contains(x)).filter(y => y == true).length == 1​

The result based on the input above looks like this:

The record that doesn't have the matching string defined in the filterValues parameter will be omitted.

Hope this helps!

Cheers😉,
Abhishek

[siwadon]

I think you can use Array.indexOf().

["100", "110", "300"].indexOf($ID) != -1

[darshthakkar]

Thank you @siwadon.
I believe for the above suggestion, I’ll have to ensure that my numbers are strings and then use that function in a mapper, right?

[siwadon · Accepted solution]

It depends. If your $ID are numbers, you can change the expression to

[100, 110, 300].indexOf($ID) != -1

I don’t understand your last question about Mapper. Since you mentioned using the Filter snap, this is for the Filter expression setting.

[darshthakkar]

Thanks @siwadon, I thought that the expression was for mapper, I will try this out in filter snap and let you know if it was successful.