topic Re: Straight table with fields from multiple data sources in QlikView

Straight table with fields from multiple data sources

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

If there are 4 to 5 data sources and we are pulling different fields from multiple data sources will the straight table function properly showing correct data on the front end UI. Will all the fields show data associatively next to each other even though they are from different data sources?

I plan to create charts and graphs using fields from different data bases. Will this all work properly.

Awaiting response. Early response appreciated.

Re: Straight table with fields from multiple data sources

Anil_Babu_Samineni — Fri, 03 Nov 2017 07:02:40 GMT

Testing is part of developer. U can create yourself and test. You came to know about Thai because we nervous to reply. And I believe this should work

Re: Straight table with fields from multiple data sources

jonathandienst — Fri, 03 Nov 2017 07:43:49 GMT

>>Will this all work properly.

Well, yes, if the data model has been properly designed and if the data load script is working to produce the designed data model....

Possibly not if you are merely opening a loading a bunch of tables with no thought to the data model design. If you need more, read this series:

Get started with developing qlik datamodels

Advanced topics for creating a qlik datamodel

Re: Straight table with fields from multiple data sources

jyothish8807 — Fri, 03 Nov 2017 12:53:24 GMT

Hi Trail,

Your data model is the key to success also be very careful while creating the Primary keys for each table.

The key has to be unique and should point to the exact value you are expecting from other table.

Mean while you can go through the source provided by Jonathan, those are very useful.

Br,

Re: Straight table with fields from multiple data sources

Anonymous — Fri, 03 Nov 2017 14:27:40 GMT

Hi,

The data sources are totally not a problem in Qlik products. You can connect all of them (the data models) in the script as you want if you know the relationship between them. One more tip in Qlikview 12 or Qliksense, you can even explore their relationship(like whether 1 field from one data source is 100% matchs 1 field from another data source).

And except that, then the mostimportant is as mentioned in the above answers: the data model and link tables (primary keys to link different table from different data source).

Zhihong