How to convert SQL crystal query into Qlikview

[varaprasad0816]

Ho to convert below SQL crystal query into Qlikview Data Model.

FROM (((((("Sabre GLBL Inc"."Sabre GLBL Inc.User" "User_CaseOwner"
INNER JOIN
"Sabre GLBL Inc"."Sabre GLBL Inc.Case" "Case"
ON "User_CaseOwner.Id"="Case.OwnerId")

Regards,

Vara

[varaprasad0816]

Below script is actual script.

Ho to convert below SQL crystal query into Qlikview Data Model.

FROM (((((("Sabre GLBL Inc". "Sabre GLBL Inc". "User" "User_CaseOwner"
INNER JOIN
"Sabre GLBL Inc". "Sabre GLBL Inc". "Case" "Case"
ON "User_CaseOwner.Id"="Case.OwnerId")

Regards,

Vara

[Brett_Bleess]

Vara, there is no need to convert things, simply use the DSN you have for the DB and use the Connect function in our load script to make the DB connection and then use the Select function to make your selections etc.

Here are some Help links with further details:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Edit_Script_dia...

Actually, just this one link puts you in the place where you can get all the info regarding how to setup things from what I can see...  Shout if you have further questions.

Here is a Design Blog post on Data Modeling as well that may be of some further help:

https://community.qlik.com/t5/Qlik-Design-Blog/Data-Modelling-Clarity-vs-Speed/ba-p/1473644

Regards,
Brett