topic Re: Soccer Database trouble in Connectivity & Data Prep https://community.qlik.com/t5/Connectivity-Data-Prep/Soccer-Database-trouble/m-p/761514#M954 <HTML><HEAD></HEAD><BODY><P>Load your data like this:</P><P></P><P>Matches:</P><P>LOAD MatchNumber, Date, HomeTeam as Team, HomeGoals as Goals, 'Home' as HomeVisitor</P><P>FROM ...</P><P></P><P>Concatenate(Matches)</P><P></P><P>LOAD MatchNumber, Date, VisitorTeam as Team, VisitorGoals as Goals, 'Visitor' as HomeVisitor</P><P>FROM ...</P></BODY></HTML> Fri, 20 Feb 2015 16:31:23 GMT Gysbert_Wassenaar 2015-02-20T16:31:23Z Soccer Database trouble https://community.qlik.com/t5/Connectivity-Data-Prep/Soccer-Database-trouble/m-p/761513#M953 <HTML><HEAD></HEAD><BODY><P>I have a soccer database that contains the fields :</P><P><STRONG>MatchNumber- Date - HomeTeam - HomeGoals - VisitorTeam - VisitorGoals</STRONG></P><P></P><P></P><P>The teams that appear in <STRONG>HomeTeam</STRONG>&nbsp; and <STRONG>VisitorTeam</STRONG> are the same because some teams may play as home and sometimes plays as visitor.</P><P></P><P>Need to put in a list box with the two fields (HomeTeam and VisitorTeam) so that when I select the team "A" show me data from home and Visitor.</P></BODY></HTML> Fri, 20 Feb 2015 16:18:26 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Soccer-Database-trouble/m-p/761513#M953 Anonymous 2015-02-20T16:18:26Z Re: Soccer Database trouble https://community.qlik.com/t5/Connectivity-Data-Prep/Soccer-Database-trouble/m-p/761514#M954 <HTML><HEAD></HEAD><BODY><P>Load your data like this:</P><P></P><P>Matches:</P><P>LOAD MatchNumber, Date, HomeTeam as Team, HomeGoals as Goals, 'Home' as HomeVisitor</P><P>FROM ...</P><P></P><P>Concatenate(Matches)</P><P></P><P>LOAD MatchNumber, Date, VisitorTeam as Team, VisitorGoals as Goals, 'Visitor' as HomeVisitor</P><P>FROM ...</P></BODY></HTML> Fri, 20 Feb 2015 16:31:23 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Soccer-Database-trouble/m-p/761514#M954 Gysbert_Wassenaar 2015-02-20T16:31:23Z