Select Expert formula question

[former_member275473]

if ({ED_IEV_EVENT_INFO.EVENT_TYPE} in ["16011101","16011102"]) then false

else if ({ED_IEV_EVENT_INFO.EVENT_TYPE} = "16011101") then true

I have this in the select expert and trying to pull records where if they have the id 16011101 then pull but if they have the same id along with 16011102 then I do not want to see the records.

Thanks for your help.

Doug

[abhilash_kumar · Accepted solution]

Hi Doug,

The selection formula works on a record basis.

So a particular row can never have two Event Types.

Could you please elaborate on " if they have the same id along with 16011102 then I do not want to see the records"

-Abhilash

[former_member205840]

Hi Doug,

As Abhishek said at any point in time you can check for one record Even_Type.  If Event_Type is concatenated with other then try this.

{ED_IEV_EVENT_INFO.EVENT_TYPE} = "16011101"

This will show all event types of "16011101"

Thanks,

Sastry

[former_member275473]

I am trying to pull records that have {ED_IEV_EVENT_INFO.EVENT_TYPE} = "16011101" but sometimes the records could have {ED_IEV_EVENT_INFO.EVENT_TYPE} = "16011102" and I don't want to pull records if both are true.

Does that make since?

[abhilash_kumar]

Still doesn't make sense.

Could you post an example dataset please?

-Abhilash