Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
ajsjoshua
Specialist
Specialist

Problems in Joining two tables

Dear all,

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.

 

Regards,

Joshua.

1 Reply
marcus_sommer

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.

- MArcus