topic Why "match" condition is not working? in Getting Data In

Why "match" condition is not working?

punithsj96 — Fri, 02 Dec 2022 05:44:56 GMT

I want to match one field value with other field values. If Value in btc field is present in NEB_Sales_Oppy_Business_Type I should get True otherwise False. I tried with the following query:

| eval Is_businees_type_matching=if(match(NEB_Sales_Oppy_Business_Type, btc), "TRUE", "FALSE")

Why I am getting False for 3 rows even the value is available in both fields.

Re: Why "match" condition is not working?

SanjayReddy — Fri, 02 Dec 2022 06:37:44 GMT

Hi @punithsj96

can you swap the fields in match and try it?

| eval Is_businees_type_matching=if(match(btc,NEB_Sales_Oppy_Business_Type), "TRUE", "FALSE")

Re: Why "match" condition is not working?

bowesmana — Fri, 02 Dec 2022 06:53:21 GMT

The problems is that the match string is a regex, so if btc would need to be

New Equipment \(NEB\)

for the match to work. See this example

| makeresults
| fields - _time
| eval NEB_Sales_Oppy_Business_Type="New Equipment (NEB)|Modernization (FRB)|Modernization (TRB)", btc="New Equipment (NEB)", btc1="New Equipment \(NEB\)"
| eval Is_businees_type_matching=if(match(NEB_Sales_Oppy_Business_Type, btc), "TRUE", "FALSE")
| eval Is_businees_type_matching1=if(match(NEB_Sales_Oppy_Business_Type, btc1), "TRUE", "FALSE")

Re: Why "match" condition is not working?

punithsj96 — Fri, 02 Dec 2022 06:54:40 GMT

Hi @SanjayReddy

Thanks for your response, I tried still its not working.

Re: Why "match" condition is not working?

ITWhisperer — Fri, 02 Dec 2022 06:59:35 GMT

Try replacing the open and close brackets in the btc field

| eval Is_business_type_matching=if(match(NEB_Sales_Oppy_Business_Type, replace(replace(btc,"\)","\)"),"\(","\(")), "TRUE", "FALSE")

Re: Why "match" condition is not working?

punithsj96 — Fri, 02 Dec 2022 07:15:32 GMT

@bowesmana, thanks for your response its working now as per my requirement.

Re: Why "match" condition is not working?

punithsj96 — Fri, 02 Dec 2022 07:19:55 GMT

Hi @ITWhisperer , yes its also working thanks for the support and response.

topic Why &quot;match&quot; condition is not working? in Getting Data In

Why "match" condition is not working?

Re: Why "match" condition is not working?

Re: Why "match" condition is not working?

Re: Why "match" condition is not working?

Re: Why "match" condition is not working?

Re: Why "match" condition is not working?

Re: Why "match" condition is not working?

topic Why "match" condition is not working? in Getting Data In