Discussion Board for collaboration on QlikView Scripting.
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,
I guess your talking about denormalizing your data model. The simple way is a left join as follows:
Load * Resident OptionLike;
Drop Table OptionLike;
Hope it will help
Plz. go thru Snow Flake/Start Schema, Fact Tables, JOINs etc also attached the link which might be useful
Normalized vs deNormalized load