Tell me how to compare two tables

[#1]

Hi,

I have two tables with the same field names, such as Table-A  and Table-B. Table-A includes some of the same records of Table-B. When I have to extract the records from Table-A which do not exist in Table-B, what shall I do?

[#2]

Hi Charusama

Are you doing this in the script? Try using "where not exists(field1, field2)"  after a load.

If you are doing it in the document itself, eg a in a table chart, then I would use a test on a value in a field in table b that you always know will be populated  - for example an id field (although you may need to create it).

An example would be =if(isnull(B_ID),.....). You could also do this in script if you wanted.

Is this useful?

Erica

[#3]

Hi Erica,

Thank you for your reply. I cannot reply to you on the QlikCommunity site, so I will reply to your

email.

If possible, I would like to get a sample script. Is it possible for you to send me this kind of

QlikView script.

Thanks,

Chiharu (Charusama)