comparing tables from differnt databases

Tue, 01 Dec 2009 01:16:02 GMT

Hi everybody

I'm trying to import one database into a new one using QlikView to montior this process.

I'm exporting some data from my old_db.mdd; than I Import this data in my new_db.mdb

Old_db and new_db have differnte primary key but new_db has a text field where i store my old_db primary key so that I can always compare data.

Now the problem is that for an error I miss some record in my old_db.

Loading data in QlikView I create a table where i compare primary key within my two db: every record where I can see only old db ID is a missing record.

Something like this:

|OLD_DB| NEW_DB |

| A1 | 1 |

| A2 | - |

| A3 | 2 |

| A4 | 3 |

| A5 | - |

For sure A2 and A5 are missing records.

The problem is how to filtere missing records becuse the empy filed ar not loaded filed with a null vlaue so I can't use NullASValue fuction and as my db has 500k records i can not export table in xls...

Is there any way to solve this problme with qlik view or I have to uce a script in access?

Thank you so much

Alberto

comparing tables from differnt databases

prieper — Tue, 01 Dec 2009 02:49:50 GMT

Either you enter a calculated field, like IF(LEN(TRIM(NEW_DB)) = 0, ''N/A', NEW_DB) AS NEW_DB1. Likewise you may create a calculated field with same logic behind.

HTH
Peter

topic comparing tables from differnt databases in QlikView

comparing tables from differnt databases

comparing tables from differnt databases