Integration Manager Advanced ODBC

(0) Share

Report

Posted on by TracySam

211

I am setting up an Integration for SOP transactions with payments using an Excel file. I have setup an advanced ODBC integration but I need to be able to sum the payment amounts in the header record and this is not working, I have the following query for the header :

Select DISTINCT ['Sales Line Items - $'].[SOP Type], ['Sales Line Items - $'].[COLLECTION DATE], ['Sales Line Items - $'].[Patient ID], ['Sales Line Items - $'].[SAMPLE ID], ['Sales Line Items - $'].LOCATION, sum(['Sales Line Items - $'].[Unit Price]) From ['Sales Line Items - $']

Once I add the sum criteria for the unit price (this contains the amount received) then when I try to preview the source I receive a message that there are no columns defined. What do I need to change to get this to work ?

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

L Vail 65,271 on at

Like (0)

Report

Hi,

I do not recognize these field names, so you have me at a disadvantage. I would probably create more sources from a flattened query. You could use the Over with Partition By statements to get your totals in the same query as your detail.

Kind regards,

Leslie

Was this reply helpful? Yes No