Measuring the gap between two matching tables

pgarcia75 — Wed, 20 Jul 2011 11:22:21 GMT

Hello

I have two tables:

Table 1, with columns A, B and C

and Table 2 with columns A, D and F

These two tables are linked by the field A (same name)

I would like to count the number of rows in the table 1, with column A does not match with table B and ditto for the table 2, the number of rows in the table 2, with the column A does not match with the table A

thank you

Measuring the gap between two matching tables

Wed, 20 Jul 2011 13:16:52 GMT

Hi P,

you can't count key-fields, in your case column "A". If you need this, create a surrogato key (my fav for this is using the autonumber() - function) and decide wich column A you want to keep. If you need to count both columns A, my suggestion for your code would be similar to this:

LOAD

autonumber(A,1) AS A_ID, // key field for linking the tables

A as A_1

From Table1

....

LOAD

autonumber(A,1) AS A_ID,

A as A_2

From Table2

Regards, Roland

topic Measuring the gap between two matching tables in QlikView

Measuring the gap between two matching tables

Measuring the gap between two matching tables