Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I've always thought that the mapping tables are automatically deleted after reloading the document, but I have a qlikview document with several millions of rows, and plenty of mapping tables.
If I use the mapping tables, the document gets almost the double of the space.
Is there any way to check if a mapping table was completely deleted?
Regards, Marcel.
Hi Marcel.
I don't think you need to check, they do get deleted after reload.
If mapping tables were there, your model would be screwed up.
Use a system table to verify.
Salutes.
Hi again.
You can set some drop statements at the end. If they work, maps were still there, otherwise the weren't.
mapping tables get deleted automatically, you do not need to worry about.
and the only way you can check, in table viewer, weather they are there are not.
If your mapping tables are still there, you have done something wrong in the Script.
Quarters_Map:
Mapping LOAD
rowno() as Month,
'Q' & Ceil(rowno()/3) as Quarter
Autogenerate(12);
The above will be dropped after the script runs, even if it isn't used.
BIll
Have you checkd if you have synthetic keys or any other reason for the space growth? I also agrre with the rest of colleagues that mapping tables are deleted after reload (they, and their fields, do not appear in the table viewer)
Regards!
Hi Marcelo,
Make sure you add the "Mapping" statement before the Load statement. This will be recognized by Qlikview as a mapping table and will be automatically deleted.
JV
BI Experience | A place to share our Business Intelligence experiences