Data Model Structure

[n1ef5ng1]

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

[Kushal_Chawda]

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

[prma7799 · Accepted solution]

PFA...

[mangalsk]

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)

[Kushal_Chawda]

n1ef5ng1‌

Is my answer was something different?