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 |