topic Re: Duplicate Fact Table and Rename all fields in QlikView

Duplicate Fact Table and Rename all fields

2908nmadao — Thu, 11 Jun 2015 15:43:06 GMT

Dear community members,

I have a quiet complex data model with no synth keys at all. I have a LinkTable where I store all KeyFields and connect all other fact tables.

I came up to an issue now that I don't seem to be able to resolve.

I need to associate 3 different tables to a single calendar in order to calculate 3 different SLAs and measurements.

Could you please tell me if there is a way of duplicating a fact table/rename all fields/drop the duplicated table?

Thank you very much for your help!

Kind regards,

/NA.

Re: Duplicate Fact Table and Rename all fields

Gysbert_Wassenaar — Thu, 11 Jun 2015 18:14:12 GMT

Duplicating fact tables sounds like a rather bad idea to me. I'm pretty sure there's another possible solution. Can you explain your data model in more detail and what you're trying to achieve as end result. What's the problem that you think duplicating your fact table is the answer for?

If you're not interested then look at the QUALIFY and UNQUALIFY keywords:

QUALIFY *;

MyDuplicateFactTable:

LOAD * RESIDENT MyFactTable;

UNQUALIFY *;

Re: Duplicate Fact Table and Rename all fields

Thu, 11 Jun 2015 18:35:51 GMT

Please post qvw with some test data.

Re: Duplicate Fact Table and Rename all fields

MarcoWedel — Thu, 11 Jun 2015 20:01:27 GMT

"3 different tables to a single calendar" sounds like a use case of

Canonical Date

hope this helps

regards

Marco