I have two data provider both providers share a possible 3 values. I am doing a query where I am testing a value of providerA against the list of the same values in ProviderB. I am finding I always get a result of true.
I broke down what I am actually attempting into the following scenario: = <Cardholder Id(ILN Value)> InList (<Cardholder Id(Kiosk User Cardholder List)>))
Always returns true
actual code:
= If <Transaction Date®> Between (<From_Date - R> ,<To_Date - R>) And <Cardholder Id(ILN Value)> > 0 And >= 1 Then 1 Else If <Cardholder Id(ILN Value)> > 0 And <Cardholder Id(ILN Value)> InList (<Cardholder Id(Kiosk User Cardholder List)>) Then 2 Else If (<Cardholder Id(ILN Value)> > 0) Then 3 Else 0
Provider A:
Cardholder Id Transaction Date® Store Visits Amount Spent
Store Id Ext Initials Kiosk Visits
-99999999999 2202 1 5.18 140 WE 1
16051 2202 1 1.75 140 WE 1
16187 2202 1 2.49 140 WE 1
16265 2202 1 2.19 140 WE 0
16412 2202 1 1.25 886 FL 1
16466 2202 1 3.18 140 WE 1
16512 2202 1 1.15 140 WE 1
16647 2202 1 1.99 140 WE 1
16772 2202 1 2.72 140 WE 1
17045 2202 1 2.69 140 WE 0
Provider B:
Initials Store Id Ext Cardholder Id
WE 140 16076
WE 140 16944
WE 140 17023
WE 140 17045
WE 140 17158
WE 140 17180
WE 140 17206
WE 140 17349
As you cans see there are values that are not in both providers.
Does the InList Operator support data in this manner?
The variables from both providers are probably linked together. This will cause the InList comparison to return true.
I have worked around this by employing a user object. For example I would create a user object on provider B named Cardholder Id dummy and returning the Cardholder Id field. I would not link the Cardholder Id dummy field to the other Cardholder Id fields. You can then perform the InList comparison as follows: =<Cardholder Id(Provider A)> InList (<Cardholder Id dummy(Provider B)>)
GCable@IALN.COM 01/25/00 12:25PM >>>
I have two data provider both providers share a possible 3 values. I am doing a query where I am testing a value of providerA against the list of the same values in ProviderB. I am finding I always get a result of true.
I broke down what I am actually attempting into the following scenario: = <Cardholder Id(ILN Value)> InList (<Cardholder Id(Kiosk User Cardholder List)>))
Always returns true
actual code:
= If <Transaction Date(R)> Between (<From_Date - R> ,<To_Date - R>) And <Cardholder Id(ILN Value)> > 0 And >= 1 Then 1 Else If <Cardholder Id(ILN Value)> > 0 And <Cardholder Id(ILN Value)> InList (<Cardholder Id(Kiosk User Cardholder List)>) Then 2 Else If (<Cardholder Id(ILN Value)> > 0) Then 3 Else 0
Provider A:
Cardholder Id Transaction Date(R) Store Visits Amount Spent
Store Id Ext Initials Kiosk Visits
-99999999999 2202 1 5.18 140 WE 1
16051 2202 1 1.75 140 WE 1
16187 2202 1 2.49 140 WE 1
16265 2202 1 2.19 140 WE 0
16412 2202 1 1.25 886 FL 1
16466 2202 1 3.18 140 WE 1
16512 2202 1 1.15 140 WE 1
16647 2202 1 1.99 140 WE 1
16772 2202 1 2.72 140 WE 1
17045 2202 1 2.69 140 WE 0
Provider B:
Initials Store Id Ext Cardholder Id
WE 140 16076
WE 140 16944
WE 140 17023
WE 140 17045
WE 140 17158
WE 140 17180
WE 140 17206
WE 140 17349
As you cans see there are values that are not in both providers.
Does the InList Operator support data in this manner?