Exists() question!

[#1]

Hi people!

I am trying to pick records from a transactions qvd-file using the exists() function. Like this:

LOAD %Date,

     %GL_Date,

     'Transactions REG' as Source,

     %ExecutingDepKey,

     %ResponsibleDepKey,

     %Project,

     %EmpNo,

     %ProjectTaskKey,

     %Activity,

     QuantityRegistered as [Registered Quantity],

     BillingPriceRegisteredBase as [Registered Billing Price],

     CostPriceRegisteredBase as [Registered Cost Price],

     QuantityInvoiced as [Invoiced Quantity],

     BillingPriceUpDownBase as [Up/Down],

     QuantityUpDown as [Up/Down Quantity],

     BillingPriceInvoiceBase as [Invoiced Billing Price],

     OrigReveueRecognizedBase as [Revenue Recognized at Registration],

  RevenueRecognizedBaseChange as [Revenue Recognized at Invoicing]

FROM

$(DataStagePath)\FACT_Transactions.qvd

(qvd)

Where Exists(%ResponsibleDepKey) OR Exists(%ExecutingDepKey)

;

But the where statement gives me all transactions. When I use only one of the conditions it works.

Can I not use exists() with an OR?

Best regards
Trond E

[tresB]

I am sure that you must be sure, still, to confirm let me ask - are you sure that you want exists() and not NOT exists()  ?

[rustyfishbones]

you can say

WHERE EXISTS (%ResponsibleDepKey , %ExecutingDepKey)

[jagan]

HI,

Can you attach full script, it is difficult to understand.

Regards,

Jagan.

[rbecher]

I guess you mean AND?

Where Exists(%ResponsibleDepKey) AND Exists(%ExecutingDepKey)