Issue with JOIN

[Anonymous]

  Hello experts,

I am facing some strange problem with join. All the fields A, B, C, D are loaded in text format in qlikview and getting joined. But somehow join is not working correctly if you can have a look and share your view.

Table A : coming from spreadsheet							Table B: coming from qvd
A	B	C	D	flag			A	B	C	D	Item
300	01	07	43	2			300	01	07	43	S1
300	01	08	43	3			300	01	07	43	S2
							300	01	07	43	S3
							300	01	07	43	S4
TABLE A JOIN TABLE B							Ideally this should be the result
A	B	C	D	flag	Item		A	B	C	D	flag	Item
300	01	07	43	2			300	01	07	43	2	S1
300	01	07	43		S1		300	01	07	43	2	S2
300	01	07	43		S2		300	01	07	43	2	S3
300	01	07	43		S3		300	01	07	43	2	S4
300	01	07	43		S4		300	01	08	43	3
300	01	08	43	3

Thanks

[Anonymous]

I agree * does not work efficiently always. I hardly use * but it was not my main application I was just resizing data for load when I came across this issues.