Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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

Re: Normalization

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

Re: Normalization

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

Normalized vs deNormalized load