Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
How come your Table2 and Expected table is same?
Can you check it once?
Hi,
I have corrected the expected table.
Thanks!
Pooja
Hi,
Left Join is not giving right total amount. let me know any other suggestion.
Thanks.
Pooja
This is not working. i am not getting right total_amt.
Suggesting any other way?
Thanks,
Pooja.
Hi
Please see the output screenshot for the below script.
I am getting the expected output upon selection of CURR_USD='usd'
TableA:
Load * 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
];
TableB:
Load * 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
];