Deleting mapping tables question

[marcel_olmo]

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.

[christian77]

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.

[christian77]

Hi again.

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

[israrkhan]

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.

[Bill_Britt]

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

[salto]

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!

[jvitantonio]

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