Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

OLEDB Read Failed Error

I have the following Script:

Screenshot 2017-08-20 17.50.15.png

When i  load the above script i get an OLEDB Read Failed error message.  What is wrong in the Script?

13 Replies
Anonymous
Not applicable
Author

Thanks Antonio.  I am getting the following error message with the SQL statement:

Screenshot 2017-08-21 13.50.31.png

antoniotiman
Master III
Master III

SQL Select

Branch,[Retail Pharmacy],[Script Number],

Count(Distinct [Script Number]) as Rx

from PharmaMarketAudit.dbo.tblDatawarehouseConsolodatedCleanStage

Group By

Branch,

[Retail Pharmacy],

[Script Number];

Anonymous
Not applicable
Author

Many thanks Antonio

Anonymous
Not applicable
Author

Thanks Mayuresh