Connecting two tables

[poooja]

Dear Qlikies,

I have an issue while connecting 2 tables. i kept a common column and joined the table but it's not giving correct output.

Please guide me how to connect this 2 table to get right output.

Requirement is: i need to get the data of amount spend by USD from Table B. Output table should have below columns.

Table A  

Table B 

Expected Out Put

Thanks! 

Pooja

[PrashantSangle]

Hi,
try below

TableA:
Load ID,TYPE,Total_Amount,CURR_USD,
ID&'-'&CURR_USD as key
Inline
[
ID,TYPE,Total_Amount,CURR_USD
10A,car,100,cad
10A,home,200, cad
10A,home,200, usd
10B,hotel,200, eur
10B,Restraurant,300, eur
10C,Flight,500, usd
10D,Restraurant,500, usd
20A,Restraurant,300, usd
20A,hotel,400, usd
20B,home,200, gbp
];

Left Join

Load ID&'-'&Curr as key,
Name
Inline
[
ID, ExpAmount, Curr, Name
10A, 500, usd, john
10B, 500, eur, john
10C, 500, usd, john
20A, 700, usd, peter
20B, 200, gbp, peter
10D, 500, usd, john
];

Regards,
PRashant Sangle