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?
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.
