Join 2 tables. Need help.

[#1]

Greetings to all!

The help to the beginner is necessary.

There are 2 tables of the facts: Move and Plan.

Move:
idDate, idFirma, idGoods,idCustomer, idManager, SumSales
Plan: idDate, idFirma, idGoodsDirect, SumPlan

idGoodsDirect - top level idGoods.


How it is better to me to connect them? It is necessary to analyze the plan the fact on firm, time, idGoodsDirect, idGoods, idCustomer, idManager.

I will be grateful for any help

Thanks

[#2]

Hi Nikolai,

Plz share Excel workbook having some sample data.

I will send you QV created by it so that you can understand it better.

[#3]

A 'LEFT JOIN LOAD DISTINCT' statement should do this. It what I used when facing a similar problem to what you have described here.

[#4]

Hi Nikolai,

You will get comparisions Sales Vs Plan only for idDate, idFirma, idGoods as Customer and Manager are not available in Plan Table.

You can use the code in this structure:

idGoodsDirect

LOAD idGoodsDirect AS idGoods FROM idGoodsDirect;

Move:

LOAD idDate, idFirma, idGoods, idCustomer, idManager, SumSales FROM Move;

CONCATENATE

LOAD idDate, idFirma, idGoodsDirect AS idGoods SumPlan FROM Plan;

This will create one dimension table and other fact table with Sales and Plan consolidated data.

Hope, it would help you.

Regards,

Raj Kishor

[#5]

you make composite key

then link with first table.

Regards

Ashish

[#6]

Hi, In attachment a file with the data

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/7215.TB01_5F00_20100914_5F00_111439.xls:550:0]

[#7]

Hi,

Plz refer to the attachment.

To connect two tables in this case, you don't need any special functions.

Plz go through the script (Ctrl+E).

Also, you can see Table Viewer (Ctrl+T) to understand how these two tables are connected.

Let me know if you don't understand.

Happy Thoughts