topic Re: merging two tables in QlikView

merging two tables

arulsettu — Mon, 05 May 2014 08:08:45 GMT

i have two tables accounts and orders with no common field. now how can i create link between these two tables?

Re: merging two tables

alexandros17 — Mon, 05 May 2014 08:12:49 GMT

1) Leave them as they are, all combinations will be available in the objects.

2) Join them to obtain a unique table (if tables are big, the join will be slow)

Hope it helps

Re: merging two tables

its_anandrjs — Mon, 05 May 2014 08:13:26 GMT

Why you need to link them and but there is no relation between them why you link them otherwise you can concatnate both tables and take it to the single table.

Re: merging two tables

arulsettu — Mon, 05 May 2014 08:15:30 GMT

can u guys give a example?

Re: merging two tables

alexandros17 — Mon, 05 May 2014 08:19:24 GMT

If your tables are TAB1 and TAB2:

SELECT * FROM TAB1;

join

SELECT * FROM TAB2;

Remember: this solution gives you all the combination af values from both the tables, concatenation gives you only a table but values from a table will not have values from the other table

Re: merging two tables

its_anandrjs — Mon, 05 May 2014 08:20:56 GMT

Write like

Accounts:

Load

*, 'Accounts' as TableFlag

From accounts;

Concatenate(Accounts)

Load

*, 'Orders' as TableFlag

From orders;

Or You can join then also

Accounts:

Load

*, 'Accounts' as TableFlag

From accounts;

Join

Load

*, 'Orders' as TableFlag

From orders;

But if the data is meaning full in both tables then take it into single table if you have sample then provide please.

Re: merging two tables

arulsettu — Mon, 05 May 2014 08:26:52 GMT

this is accounts table

this one is orders table

using star schema. orders table is fact table. but no common field between two tables

shall i use concat or join?

Re: merging two tables

arulsettu — Mon, 05 May 2014 08:35:55 GMT

these are the two tables i need to display accounts number and account balance

Re: merging two tables

its_anandrjs — Mon, 05 May 2014 08:36:32 GMT

Is there any common date between this two table find that by the common date i believe you can join them and use it in single Order fact table or combination of any two fields also you can join them.

Re: merging two tables

alexandros17 — Mon, 05 May 2014 08:36:38 GMT

An example:

If you join for each value of Account Number you will have all Customers Id values :

1060 1

1060 41

.... and so on

If you concatenate:

1060 -

- 1

- 41

Re: merging two tables

its_anandrjs — Mon, 05 May 2014 08:40:51 GMT

accounts number and account balance are in single table you can use them easily and display its chart where is problem.

Re: merging two tables

arulsettu — Mon, 05 May 2014 08:44:56 GMT

ya but i am having another table called customer it have country. if i select country have to show account balance.

Re: merging two tables

arulsettu — Mon, 05 May 2014 08:54:34 GMT

table view

Re: merging two tables

its_anandrjs — Mon, 05 May 2014 08:59:34 GMT

Try to find out in the database if there is any other table which has a relation ship with this tables then use that table as a link table between the Orders and the Accounts or you can join them also otherwise in the data base create another view that has a relation between the Orders and accounts based on other table and load that view in the qlikview to link the tables.

Re: merging two tables

arulsettu — Mon, 05 May 2014 09:25:32 GMT

based on table can u give example for join?