topic Re: Create star schema in QlikView https://community.qlik.com/t5/QlikView/Create-star-schema/m-p/352353#M703146 <HTML><HEAD></HEAD><BODY><P>It's up to you</P><P>I think you can link all the tables where each donor_id has only one value (cellno, edress, etc)</P></BODY></HTML> Mon, 16 Jul 2012 12:30:32 GMT 2012-07-16T12:30:32Z Create star schema https://community.qlik.com/t5/QlikView/Create-star-schema/m-p/352347#M703140 <HTML><HEAD></HEAD><BODY><P>Hello.</P><P></P><P>Please see the attached file.</P><P></P><P>I have problems joining my tables to create a start schema, when I join table Donors with table Donor_Email and Donor_Cellphone. Count(DONOR_ID) returns way to many occurrences... </P><P></P><P>Is this the right way to perform a join to create star shema or what am I doing wrong?</P><P></P><P>Regards</P><P>Databyran</P></BODY></HTML> Mon, 16 Jul 2012 12:06:41 GMT https://community.qlik.com/t5/QlikView/Create-star-schema/m-p/352347#M703140 2012-07-16T12:06:41Z Re: Create star schema https://community.qlik.com/t5/QlikView/Create-star-schema/m-p/352348#M703141 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Note that Count() return the number of rows with any value in DONOR_ID. If one table has more than one record for the same value in the field DONOR_ID Count() will return the larger number.</P><P></P><P>Hope that helps.</P><P></P><P>Miguel</P></BODY></HTML> Mon, 16 Jul 2012 12:12:54 GMT https://community.qlik.com/t5/QlikView/Create-star-schema/m-p/352348#M703141 Miguel_Angel_Baeyens 2012-07-16T12:12:54Z Re: Create star schema https://community.qlik.com/t5/QlikView/Create-star-schema/m-p/352349#M703142 <HTML><HEAD></HEAD><BODY><P>probably script error</P><P></P><P>send a qvw file or part of the script</P><P></P><P></P><P><IMG src="https://community.qlik.com/legacyfs/online/emoticons/wink.png" />don't you think there are to many tables?:)</P><P>Donor_Birthyear</P><P>Donor_HasEmail</P><P>Donor_PhoneNo</P><P>Donor_Emaila</P><P>Donor_Cellph</P><P>Donor_Zipcode</P><P>...</P><P></P><P></P><P>it could be one table:)</P></BODY></HTML> Mon, 16 Jul 2012 12:13:11 GMT https://community.qlik.com/t5/QlikView/Create-star-schema/m-p/352349#M703142 2012-07-16T12:13:11Z Re: Create star schema https://community.qlik.com/t5/QlikView/Create-star-schema/m-p/352350#M703143 <HTML><HEAD></HEAD><BODY><P>Yes, i know. But is it "ok" to have several DONOR_ID since this is the key for a uniqe donor?</P><P>I can solve it by adding DISTINCT but i am wondering if it is okay to have the same DONOR_ID several times?</P><P></P><P>Regards</P><P>Databyran</P></BODY></HTML> Mon, 16 Jul 2012 12:24:26 GMT https://community.qlik.com/t5/QlikView/Create-star-schema/m-p/352350#M703143 2012-07-16T12:24:26Z Re: Create star schema https://community.qlik.com/t5/QlikView/Create-star-schema/m-p/352351#M703144 <HTML><HEAD></HEAD><BODY><P>Yes, I know there is too many tables, thats why I want to join those tables.</P><P>Should I join all tables that have DONOR_ID in common?</P><P></P><P>Regards</P><P>Databyran</P></BODY></HTML> Mon, 16 Jul 2012 12:25:55 GMT https://community.qlik.com/t5/QlikView/Create-star-schema/m-p/352351#M703144 2012-07-16T12:25:55Z Re: Create star schema https://community.qlik.com/t5/QlikView/Create-star-schema/m-p/352352#M703145 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Yes, supposedly the DISTINCT will return the number of unique values in the field. Anyway, joining tables (or using mapping tables) to reduce the number of existing tables in the model and simpilfying will help.</P><P></P><P>Think of records where the DONOR_ID might be null, but not the other fields (probably mistakes when entering data).</P><P></P><P>Hope that helps.</P><P></P><P>Miguel</P></BODY></HTML> Mon, 16 Jul 2012 12:26:40 GMT https://community.qlik.com/t5/QlikView/Create-star-schema/m-p/352352#M703145 Miguel_Angel_Baeyens 2012-07-16T12:26:40Z Re: Create star schema https://community.qlik.com/t5/QlikView/Create-star-schema/m-p/352353#M703146 <HTML><HEAD></HEAD><BODY><P>It's up to you</P><P>I think you can link all the tables where each donor_id has only one value (cellno, edress, etc)</P></BODY></HTML> Mon, 16 Jul 2012 12:30:32 GMT https://community.qlik.com/t5/QlikView/Create-star-schema/m-p/352353#M703146 2012-07-16T12:30:32Z Re: Create star schema https://community.qlik.com/t5/QlikView/Create-star-schema/m-p/352354#M703147 <HTML><HEAD></HEAD><BODY><P>Ok, so I am not able to get a "clean" star schema in this case because I have several tables where donor_id appers several times?</P><P></P><P>Regards</P><P>Databyran</P></BODY></HTML> Mon, 16 Jul 2012 12:32:53 GMT https://community.qlik.com/t5/QlikView/Create-star-schema/m-p/352354#M703147 2012-07-16T12:32:53Z Re: Create star schema https://community.qlik.com/t5/QlikView/Create-star-schema/m-p/352355#M703148 <HTML><HEAD></HEAD><BODY><P>I didn't say you can't:)</P><P></P><P>it's up to you bacouse there are some pros and cons</P><P>data structure determines your "layout job"</P></BODY></HTML> Mon, 16 Jul 2012 12:58:24 GMT https://community.qlik.com/t5/QlikView/Create-star-schema/m-p/352355#M703148 2012-07-16T12:58:24Z