How to link data from 2 data sources

[#1]

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.

[#2]

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.

[#3]

Hi Miller

Thanks for your reply.

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

Thanks

[Anonymous]

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.

[#5]

Thanks Dennis !

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

Many thanks for your suggestion.