Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
2908nmadao
Contributor III
Contributor III

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
Gysbert_Wassenaar

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

Please post qvw with some test data.

MarcoWedel

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


Canonical Date

hope this helps

regards

Marco