Using Or function

[#1]

hi All,

Can you please tell me if the below syntax is correct? I am trying to use or and like condtion together

count({<Officeaddress ={"*Delhi*","* New Delhi*","*Old Delhi*"}>} Transaction_id)

[vardhancse]

why cant u use only one condition

=count({$<Officeaddress={'*Delhi*'}>}(Transaction_ID))

as its  a wild card search it will take all the data which contains delhi

[#3]

Sorry i missed actually I need to check ND as well

[vardhancse]

as its a wild card search it will give u the count of transaction Id which contains office address *delhi*.

[#5]

Hi Sai,

Thanks foy your help but some people have written Delhi as ND so i want to pass ND as well in or condtion

[#6 · Accepted solution]

So wouldn't you just add 'ND'

count({<Officeaddress ={"*Delhi*","* New Delhi*","*Old Delhi*", 'ND'}>} Transaction_id)

[Marcio_Campestrini]

Hi Sasi.

And what if you change the ND to New Delhi in the script, putting a condition in the script?

[vardhancse]

hi you can  use applymap function for ND to New Delhi

Applymap('CD',Officeaddress) as Officeaddress,

we can use excel sheet to get description from code