topic Re: Normalization in QlikView https://community.qlik.com/t5/QlikView/Normalization/m-p/707709#M672979 <HTML><HEAD></HEAD><BODY><P>Hi Nat,</P><P></P><P>I guess your talking about denormalizing your data model. The simple way is a left join as follows:</P><P></P><P></P><P> Left Join(Option)</P><P>Load * Resident OptionLike;</P><P></P><P>Drop Table OptionLike;</P><P></P><P>Hope it will help</P></BODY></HTML> Tue, 19 Aug 2014 15:55:11 GMT bgerchikov 2014-08-19T15:55:11Z Normalization https://community.qlik.com/t5/QlikView/Normalization/m-p/707708#M672978 <HTML><HEAD></HEAD><BODY><P>Hey guys,</P><P></P><P>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?</P><P></P><P>Your help is much appreciated.</P><P></P><P>Thanks in advance,</P><P>Nat</P></BODY></HTML> Tue, 19 Aug 2014 15:49:58 GMT https://community.qlik.com/t5/QlikView/Normalization/m-p/707708#M672978 2014-08-19T15:49:58Z Re: Normalization https://community.qlik.com/t5/QlikView/Normalization/m-p/707709#M672979 <HTML><HEAD></HEAD><BODY><P>Hi Nat,</P><P></P><P>I guess your talking about denormalizing your data model. The simple way is a left join as follows:</P><P></P><P></P><P> Left Join(Option)</P><P>Load * Resident OptionLike;</P><P></P><P>Drop Table OptionLike;</P><P></P><P>Hope it will help</P></BODY></HTML> Tue, 19 Aug 2014 15:55:11 GMT https://community.qlik.com/t5/QlikView/Normalization/m-p/707709#M672979 bgerchikov 2014-08-19T15:55:11Z Re: Normalization https://community.qlik.com/t5/QlikView/Normalization/m-p/707710#M672980 <HTML><HEAD></HEAD><BODY><P>Plz. go thru Snow Flake/Start Schema, Fact Tables, JOINs etc also attached the link which might be useful</P><P></P><P><A href="https://community.qlik.com/thread/31672">Normalized vs deNormalized load</A></P></BODY></HTML> Tue, 19 Aug 2014 15:58:52 GMT https://community.qlik.com/t5/QlikView/Normalization/m-p/707710#M672980 2014-08-19T15:58:52Z