Comparing two tables

[Anonymous]

Hi, I have to tables which should have exactly the same data. I need to find  the columns that don’t match base on the same ID. See examples below. Any idea what's the best way to complete this task using qlikview? I'm using QV personal edition, so please explain the method if possible.

Thanks!

Table1

ID	Field1	Date	Value
1234	a14	12/13/15	$1245
5677	r12	3/6/15	$2561
2356	j36	2/4/13	$252

Table2

ID	Field1.A	Date.A	Value.A
1234	a14	12/13/15	$1245
5677	t36	3/16/15	$2561
2356	j36	12/4/13	$252

[petter · Accepted solution]

But it is only the ID that needs to be a dimension. The Fields can be listed as expressions. The expressions does not need to be measures/metrics but can also be strings. In the example I sent you I didn't use any aggregate function around the field-names and that will work as long as you always have one and only one distinct ID for each row.