Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Plz. go thru Snow Flake/Start Schema, Fact Tables, JOINs etc also attached the link which might be useful