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: 
Not applicable

Normalization

Hey guys,

I am a total newbie at QlikView. How do I go about normalizing signup_datetime, choice_datetime and option_like_datetime for all my tables as shown below?

Your help is much appreciated.

Thanks in advance,

Nat

2 Replies
bgerchikov
Partner - Creator III
Partner - Creator III

Hi Nat,

I guess your talking about denormalizing your data model. The simple way is a left join as follows:

Left Join(Option)

Load * Resident OptionLike;

Drop Table OptionLike;

Hope it will help

Not applicable
Author

Plz. go thru Snow Flake/Start Schema, Fact Tables, JOINs etc also attached the link which might be useful

Normalized vs deNormalized load