I have two tables header and line. I am simply joining the tables with PI_DocumentNO which is common in both tables. But unfortunately some data in the field which has same data in common doesn't joins.
Please find the screenshot. I had added another PI_DocumentNO with name header in first table and Line in second table.
I think it's rather not a join-issue else some header or lines haven't just one value else they are NULL. This might be a data-quality issue but it mustn't mandatory because there might be valid reasons for it.
