topic Data Model Structure in QlikView

Data Model Structure

n1ef5ng1 — Mon, 24 Jul 2017 09:04:52 GMT

Hi Everyone I have a question on data joining

I have this two table (actual fact is 3 but i would want to simplify it)

Table 1 consist of : Country, Warehouse, Type, Delivery_Mode and the list of KPIs (aggregated such as volumes, revenue , cancellation)

I have Table 2 that consist of Country, Warehouse, Type and the list of KPIs (Average_Time from shipped to delivered etc)

I would like to combine this two table and do note that table 2 does not have Delivery Mode.

When I do a left join table 1, it give me duplicate info on table 2 data with the delivery mode. How can I make it that it is unique and it should show a separate record

Re: Data Model Structure

Kushal_Chawda — Mon, 24 Jul 2017 09:43:11 GMT

Perform Concatenate operation between two tables. Rename your table two fields according to table 1 and perform concatenate

Table1:

LOAD Country, Warehouse, Type, Delivery_Mode,KPI1,KPI2,KPI3

FROM table1

concatenate(Table1)

LOAD Country, Warehouse, Type,KPI4,KPI5

FROM table2

Re: Data Model Structure

prma7799 — Mon, 24 Jul 2017 09:53:14 GMT

PFA...

Re: Data Model Structure

mangalsk — Mon, 24 Jul 2017 10:01:52 GMT

You just need to add missing field with null data as below and all other columns will have same name:

Load

Country, Warehouse, Type, Delivery_Mode and the list of KPIs,

(aggregated such as volumes, revenue , cancellation)

concate

Country, Warehouse,null() as Delivery_Mode, Type and the list of KPIs (Average_Time from shipped to delivered etc)

Re: Data Model Structure

Kushal_Chawda — Mon, 24 Jul 2017 10:03:14 GMT

n1ef5ng1‌

Is my answer was something different?