Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

match values of 2 columns

Hi, I have 2 columns called 'itemnum', from different tables, that contain common values. When I made this column name primary key, and created a tablebox, I discovered that the values do not match but instead they just appear individually in the table, creating duplicate values in the itemnum column. How do I match the same values? Because I also want to display other data relating to the itemnum and there are null columns all over as the itemnum values repeat, displaying only data for the the related columns that appear in their respective table/data source. Thanks.

1 Reply
Not applicable
Author

can you attach the app please. It shouldn't display duplicate values.. Can you look at the table viewer to see if those 2 tables are joined by "itemnum"?