Build Data Model from Query

ashishp — Mon, 31 Oct 2022 12:45:39 GMT

Hi There

I have one query which is taking lot of time to run.

Want to convert this query into Qlik Sense Data model.

any suggestions?

Thanks in advance.

Re: Build Data Model from Query

RafaelBarrios — Mon, 31 Oct 2022 22:07:15 GMT

hi @ashishp

If you want to use that query, you should try using JOINS statements instead of all those WHERE conditions. Your database manager will thank you, and the users of that application will be less affected

The advisable thing would be to do the complete extractions of the tables, without filtering or renaming and then build your model using instructions such as concatenate, joins or letting your tables be connected by the fields that have the same names.

if you are not familiar with the use of the script, you can try to use the Data Manager

https://www.youtube.com/watch?v=b2wFIjqV8U8&list=PLkRFvjyuHFvKDnIvwny2qKxKSjn-DkI3k

If you want to have better control on the data, you can try to do it manually in the script

https://www.youtube.com/watch?v=rPK-1xE6VLw&t=179s

In qlik it is always advisable to make an ETL layered model, where in a first app you do the extraction and save QVD files.

In another app you do the transformation renaming fields, concatenating and/or joinings tables and saving QVDs already prepared to be consumed.

and finally you make an app that does not contain any logic and only loads the second layer of QVDs

Hope this helps.

Best,

help users find answers! Don't forget to mark a solution that worked for you & to smash the like button! 🙂

topic Re: Build Data Model from Query in Connectivity & Data Prep

Build Data Model from Query

Re: Build Data Model from Query