topic Re: Create one table from 2 different tables in QlikView

Create one table from 2 different tables

Anonymous — Tue, 08 Oct 2013 12:15:58 GMT

I have 2 tables :

QV_RET_OVED_VW with the columns :

COMMERCIAL_NUM,

COMMERCIAL,

GROUPE_OVED

QV_RET_FAMILLES_VW with the columns :

COMMERCIAL,

FAMILLE_NUM

YEARMONTH

I want to create a table QV_RET_GROUPE_OVED with the columns :

GROUPE_OVED

COUNT(FAMILLE_NUM)

That represents the count of FAMILLE_NUM for each GROUP_OVED and by YEARMONTH

I have tried with the expression 'Resident' but it doesn't work

Thank you for your help

Regards

Re: Create one table from 2 different tables

Gysbert_Wassenaar — Tue, 08 Oct 2013 12:22:55 GMT

Just load the tables:

QV_RET_OVED_VW:

Load

COMMERCIAL_NUM,

COMMERCIAL,

GROUPE_OVED

From QV_RET_OVED_VW_source;

QV_RET_FAMILLES_VW

Load:

COMMERCIAL,

FAMILLE_NUM,

YEARMONTH

From ...QV_RET_FAMILLES_VW_source...;

Then in the UI create a new straight table with GROUPE_OVED as dimension and count(FAMILLE_NUM) as expression. That's all you need.

If you feel you need to do it all in the script you'll have to join the tables:

Table1:

Load

COMMERCIAL_NUM,

COMMERCIAL,

GROUPE_OVED

From QV_RET_OVED_VW_source;

join (Table1)

Load:

COMMERCIAL,

FAMILLE_NUM,

YEARMONTH

From ...QV_RET_FAMILLES_VW_source...;

Table2:

Load GROUPE_OVED, count(FAMILLE_NUM) as Count

resident Table1

group by GROUPE_OVED;

Re: Create one table from 2 different tables

saumyashah90 — Tue, 08 Oct 2013 12:31:39 GMT

abc:
Left Join(QV_RET_OVED_VW)

Load * resident QV_RET_FAMILLIES_VW;

Master:

Load GROUPE_OVED,

Count(FAMILLE_NUM) as CountofFAMILLE

resident abc;

Re: Create one table from 2 different tables

Anonymous — Tue, 08 Oct 2013 12:34:40 GMT

Thanks for your response

But I need a table with the data and not to create a chart

Regards

Re: Create one table from 2 different tables

saumyashah90 — Tue, 08 Oct 2013 12:36:53 GMT

Hey Ankri,

One which i mentioned will make table name Master with that data

Re: Create one table from 2 different tables

Anonymous — Tue, 08 Oct 2013 12:44:59 GMT

Sorry but I don't understand

That is not working

Re: Create one table from 2 different tables

saumyashah90 — Tue, 08 Oct 2013 12:53:13 GMT

See first you load both the tables

Table1:

Load COMMERCIAL_NUM,

COMMERCIAL,

GROUP_OVED

From QV_RET_OVED_VW;

Table2:

Load COMMERCIAL,

FAMILLE_NUM,

YEAR MONTH

FROM QV_RET_FAMILLE_VW;

After this two table get loaded,

Left Join(Table1)

Load * resident Table2;

Drop table Table2;

Master:

Load Group_OVED,

Count(FAMILLE_NUM) as Count_OF_FAMILLE_NUM

resident Table1;

Drop table Table1;

So You will Have Master table fianl consisting of required data

Re: Create one table from 2 different tables

Anonymous — Tue, 08 Oct 2013 13:09:13 GMT

Thank you very much

Re: Create one table from 2 different tables

saumyashah90 — Tue, 08 Oct 2013 13:14:19 GMT

Can you please Mark it correct if it is correct

Re: Create one table from 2 different tables

Anonymous — Tue, 08 Oct 2013 13:26:01 GMT

Hi G WASSENAAR

If I have 3 tables to link, How can I do ?

Re: Create one table from 2 different tables

Anonymous — Tue, 08 Oct 2013 13:27:26 GMT

If I have 3 tables to link, how can I do ?

Re: Create one table from 2 different tables

Gysbert_Wassenaar — Tue, 08 Oct 2013 13:36:42 GMT

No idea. You'll have to show the data model and explain what the result should be. An example with some data would help.

Re: Create one table from 2 different tables

Anonymous — Tue, 08 Oct 2013 13:46:39 GMT

I addition to the tables QV_RET_OVED_VW and QV_RET_FAMILLES_VW,

I want to link the table QV_RET_FACTURATION wich colums are :

COMMERCIAL

MARGE

and to have in the final table

GROUPE_OVED (from the table QV_RET_OVED_VW)

count(FAMILLE_NUM) as Count (from the table QV_RET_FAMILLES_VW)

sum (MARGE) as SUM_MARGE (from the table QV_RET_FACTURATION )

group by GROUPE_OVED;

Thanks a lot