question Re: How to use (in) to compare variable with array? in Archives of Support Questions (Read Only)

How to use (in) to compare variable with array?

umang_instantwe — Fri, 06 Jul 2018 18:42:45 GMT

I have two flow file:

1) $.category = sport

2) $.temp_array = "music" , "sport" , "traveling"

I just want to check $.category is exist in $.temp_array or not using in expression language.

Ex.

${category:in(${temp_array})}

But it doesn't work with array or (variable). I have used this login on RouteOnAttribute processor. Instead of above example if i write like this:

${category:in("music","sport","traveling")}

then ii will give you perfect output But this is static data. Instead of this i want to use dynamic.

Please help.

Re: How to use (in) to compare variable with array?

MattWho — Fri, 06 Jul 2018 19:20:31 GMT

@umang s

The following NiFi Expression Language statement will return "true" if a match is found:

${anyDelineatedValue("${temp_array}", ","):contains("${category}")}

Thanks,

Matt

If you found this Answer addressed your original question, please take a moment to login and click "Accept" below the answer.

Re: How to use (in) to compare variable with array?

umang_instantwe — Sun, 18 Aug 2019 09:18:05 GMT

@Matt Clarke

it doesn't work.
It directly goes to unmatched. Means condition is not worked.

I have attached

flow and configuration of RouteOnAttribute processor

Configuration of RouteOnAttribute Processor

Re: How to use (in) to compare variable with array?

MattWho — Tue, 10 Jul 2018 20:18:37 GMT

@umang s

Based on your flow design above, it looks like you are trying to route FlowFiles by comparing attribute between two different FlowFiles? That will not work. NiFi is looking for both ${temp_array} and ${category} to exist on same flowfile being evaluated by the RouteOnAttribute processor.