topic How to link data from 2 data sources in QlikView

How to link data from 2 data sources

Mon, 06 Dec 2010 18:44:23 GMT

Hi All,

I have to pull the data from 2 data sources and should link them finally. For example, I have MONTH NAME field in a table from one data source and MONTH NUMBER field in a table from another data source. Finally If i want to click a value in MONTH NUMBER that should display the associated value in MONTH NAME.

How can i link the data coming from different data sources ??

Your suggestions will be highly appreciated.

Many Thanks in advance.

How to link data from 2 data sources

Mon, 06 Dec 2010 18:48:59 GMT

To link fields in QlikView, give them the same name. This will then function similar to a Join in more traditional SQL.

In your case, you also need to convert the fields to the same value type. Depending on what you have your months stored as you may need: Num(MonthName), MonthName(MonthNum) or a Case statement to manually convert them.

How to link data from 2 data sources

Mon, 06 Dec 2010 18:52:20 GMT

Hi Miller

Thanks for your reply.

Can you please give me a clear example how can i do it in QV script ??

Thanks

How to link data from 2 data sources

Anonymous — Tue, 07 Dec 2010 12:39:43 GMT

You can rename them in the loading script by adding "as NewName"

For example:

LOAD
Month as Monthnumber,
NameMonth,
FROM Database1;

LOAD
Number as Monthnumber,
Data
FROM Database2;

This will link the fields Monthnumber in both tables

If you need more help just upload your Qlikview file and I will see what I can do for you.

How to link data from 2 data sources

Wed, 08 Dec 2010 10:47:37 GMT

Thanks Dennis !

Now i got the concept how to link the data from different sources.

Many thanks for your suggestion.