two tables - need to compare two columns from each one
Hello! Thanks so much for taking the time to read this and potentially help me out!
I am importing two excel documents into Qlikview. They have the same columns (but I have given them different dimension names). I need to compare one column in each table that contain the same values (ie to see if table1_colA is missing any values that are present in table2_colA). After this, I need to look at all the values associated with table2_colA (such as table2_colB, table2_colC, etc). How would I do this?
I tried doing a join and then a noconcanteate with true and false values, but that ended up appending the two tables and so through off my whole spreadsheet. Any suggestions or advice would be most appreciated!!