Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

2908nmadao
New Contributor II

Duplicate Fact Table and Rename all fields

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.

3 Replies

Re: Duplicate Fact Table and Rename all fields

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 *;


talk is cheap, supply exceeds demand
Not applicable

Re: Duplicate Fact Table and Rename all fields

Please post qvw with some test data.

Re: Duplicate Fact Table and Rename all fields

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


Canonical Date

hope this helps

regards

Marco

Community Browser