topic Re: Deleting mapping tables question in QlikView

Deleting mapping tables question

marcel_olmo — Fri, 15 Nov 2013 10:13:15 GMT

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.

Re: Deleting mapping tables question

christian77 — Fri, 15 Nov 2013 10:17:00 GMT

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.

Re: Deleting mapping tables question

christian77 — Fri, 15 Nov 2013 10:19:42 GMT

Hi again.

You can set some drop statements at the end. If they work, maps were still there, otherwise the weren't.

Re: Deleting mapping tables question

israrkhan — Fri, 15 Nov 2013 11:24:27 GMT

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.

Re: Deleting mapping tables question

Bill_Britt — Fri, 15 Nov 2013 11:38:32 GMT

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

Re: Deleting mapping tables question

salto — Fri, 15 Nov 2013 11:42:07 GMT

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!

Re: Deleting mapping tables question

jvitantonio — Fri, 15 Nov 2013 11:43:36 GMT

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.

BI Experience | A place to share our Business Intelligence experiences