topic Error in QlikView

Error

smilingjohn — Thu, 19 Nov 2015 11:28:22 GMT

Hi All

Actaully my script was runing well unless i added Distinct to it , and now its giving the error .

Can someone tell me where I am wrong ?

ErrorSource: OraOLEDB, ErrorMsg: ORA-01791: not a SELECTed expression

Department:

SQL

SELECT

Distinct

aia.invoice_id,

AIA.vendor_id "VendorId",

......

and so on

Do i need to mention Distinct before Select or what ?

tamilarasu — Thu, 19 Nov 2015 11:32:08 GMT

Hi,

Try like,

Load distinct *;

SQL

SELECT

aia.invoice_id,

AIA.vendor_id "VendorId",

......

Thu, 19 Nov 2015 11:35:57 GMT

You can also try Group By instead of Distinct in your script.