How to make combine table when duplicates are present

[Abhishek_Noob]

I have table A & B in excel file and I have to make Table C in Qlik sense with the help of Table A & B

Table A:

A	B	E
315004910	314	3
315004910	1024	4
215004815	25	65
100495195	23	78

Table B:

A	B	D
315004910	1024	35675
315004910	314	35679
316005927	273	27509
100495195	56	55795

Table C:

A	B	E	D
315004910	314	3	35679
315004910	1024	4	35675
215004815	25	65	-
10049519	23	78	55795