topic Re: Best way dealing identical columns and multiple dates in QlikView

Best way dealing identical columns and multiple dates

Fri, 29 Mar 2013 02:02:07 GMT

I came across scenario where we have identical columns on in diffrent tables and multiple date fields. i would like to know

1. best way dealing with identical columns and at same time i want to a create master calender

Here is an example

Re: Best way dealing identical columns and multiple dates

udit_kumar_sana — Fri, 29 Mar 2013 06:58:24 GMT

Hi ,

Try to this with below link table concept:

Link_table:

load

Item as Link_table_Item,

Item_Desc as Link_table_Item_Desc,

Sales_dt as Link_table_dt,

Model as Link_table_Model

resident sales;

Concatenate

load

Item as Link_table_Item,

Item_Desc as Link_table_Item_Desc,

purchase_dt as Link_table_dt,

Model as Link_table_Model

resident purchase;

Concatenate

load

Item as Link_table_Item,

Item_Desc as Link_table_Item_Desc,

invoice_dt as Link_table_dt

resident Invoice;

Final_Link_table:

load

Link_table_Item &'-'& Link_table_Item_Desc &'-'&Link_table_dt as Key,

Link_table_Item,

Link_table_Item_Desc,

Link_table_dt,

Link_table_Model

resident Link_table;

drop Table Link_table;

-Form this key in your each individual tables also.

-and comment the Item,Item_Desc,dt,Model in each individual table.

-Use this dimensions from linktable created i.e.

Link_table_Item,

Link_table_Item_Desc,

Link_table_dt,

Link_table_Model

Regards,

Udit

Re: Best way dealing identical columns and multiple dates

Fri, 29 Mar 2013 16:47:45 GMT

Im still seeing sync key's, is this normal ?

Re: Best way dealing identical columns and multiple dates

udit_kumar_sana — Sat, 30 Mar 2013 05:35:40 GMT

Hi,

-Form this key in your each individual tables also.

-and comment the Item,Item_Desc,dt,Model in each individual table.

Regards,

Udit

Re: Best way dealing identical columns and multiple dates

Sat, 30 Mar 2013 07:05:35 GMT

Please find the attached , hope it helps

Re: Best way dealing identical columns and multiple dates

Mon, 01 Apr 2013 14:43:33 GMT

I can avoid sync key, but how do i achieve building master calender by using your model. What i was thinking , CONCATENATE all common fields and create a link table. But im not sure if it is a optimal model.