Joins a

[Kelsmer]

Hi how do i aggregate columns from two defferent Table.

Like this:

Shipment:

LOAD * Inline

[Date, Shipping
Jul-15, 10
Aug-15, 10
Sep-15, 10
Oct-15, 10
Nov-15, 10
Dec-15, 10
Jan-16, 12
Feb-16, 12
Mar-16, 12
Apr-16, 12
May-16, 12
Jun-16, 12
Jul-16, 12
Aug-16, 12
Sep-16, 12
Oct-16, 12
Nov-16, 12
Dec-16, 12
Jan-17, 15
Feb-17, 15
Mar-17, 15
Apr-17, 15
May-17, 15
Jun-17, 15];
Inner Join
Exchange_Rate:
LOAD
"Month" as Date,
"Exchange Rate (ARC to ZAR)"as "Exchange_Rate"
FROM [lib://DataFiles/Tables.xlsx]
(ooxml, embedded labels, table is [Table 10]);

Shipments:

Load Date , Num([Shipping]*Exchange_Rate) as "Shipment Cost"
Resident Shipment;

[Saravanan_Desingh]

Try something like this,

Shipment:
LOAD * Inline
[Date, Shipping
Jul-15, 10
Aug-15, 10
Sep-15, 10
Oct-15, 10
Nov-15, 10
Dec-15, 10
Jan-16, 12
Feb-16, 12
Mar-16, 12
Apr-16, 12
May-16, 12
Jun-16, 12
Jul-16, 12
Aug-16, 12
Sep-16, 12
Oct-16, 12
Nov-16, 12
Dec-16, 12
Jan-17, 15
Feb-17, 15
Mar-17, 15
Apr-17, 15
May-17, 15
Jun-17, 15];
Inner Join
Exchange_Rate:
LOAD
"Month" as Date,
"Exchange Rate (ARC to ZAR)"as "Exchange_Rate"
FROM [lib://DataFiles/Tables.xlsx]
(ooxml, embedded labels, table is [Table 10]);

Left Join(Shipment)
Shipments:
Load Date , Num([Shipping]*Exchange_Rate) as "Shipment Cost"
Resident Shipment;

Left Join(Shipment)
Load Date, Sum([Shipment Cost]) As Value
Resident Shipment
Group By Date;