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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

can you create a microsoft excel OBDC query file (.dqy)

Can you use this type of file to extract your data in data load?

SELECT "PhTheraChange"."PhNPI", "PhTheraChange"."GPIDrugGroup", "PhTheraChange"."GPIDrugClass", "PhTheraChange"."GPIDrugSubClass", "PhTheraChange"."GPIDrugNameCd", "PhTheraChange"."Product", "PhTheraChange"."TheraType", "PhTheraChange"."ReplaceNDC", "PhTheraChange"."NDC", "PhTheraChange"."Sig", "PhTheraChange"."ReplaceCCID", "PhTheraChange"."CCID", "PhTheraChange"."PhTCguid", "Physicians"."PhLName", "Physicians"."PhFName", "PhTheraChange"."InsID", "InsPlans"."InsName", "PhTheraChange"."FacID", "Facilities"."FacName", "FacGroupDefs"."FGName", "FacGroups"."FGID"   FROM   (((("Fac"."dbo"."PhTheraChange" "PhTheraChange" FULL OUTER JOIN "Fac"."dbo"."Physicians" "Physicians" ON "PhTheraChange"."PhNPI"="Physicians"."PhNPI") FULL OUTER JOIN "Fac"."dbo"."InsPlans" "InsPlans" ON "PhTheraChange"."InsID"="InsPlans"."InsID") INNER JOIN "Fac"."dbo"."Facilities" "Facilities" ON "PhTheraChange"."FacID"="Facilities"."FacID") INNER JOIN "Fac"."dbo"."FacGroups" "FacGroups" ON "PhTheraChange"."FacID"="FacGroups"."FacID") INNER JOIN "Fac"."dbo"."FacGroupDefs" "FacGroupDefs" ON "FacGroups"."FGID"="FacGroupDefs"."FGID"   WHERE   NOT ("PhTheraChange"."FacID"='mstr' OR "PhTheraChange"."FacID"='test') AND "FacGroups"."FGID"<>'CYCLE'   ORDER BY "FacGroupDefs"."FGName", "PhTheraChange"."FacID", "PhTheraChange"."PhNPI", "PhTheraChange"."GPIDrugGroup", "PhTheraChange"."GPIDrugClass", "PhTheraChange"."GPIDrugSubClass", "PhTheraChange"."GPIDrugNameCd", "PhTheraChange"."ReplaceNDC", "PhTheraChange"."InsID"

0 Replies