Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a soccer database that contains the fields :
MatchNumber- Date - HomeTeam - HomeGoals - VisitorTeam - VisitorGoals
The teams that appear in HomeTeam and VisitorTeam are the same because some teams may play as home and sometimes plays as visitor.
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.
Load your data like this:
Matches:
LOAD MatchNumber, Date, HomeTeam as Team, HomeGoals as Goals, 'Home' as HomeVisitor
FROM ...
Concatenate(Matches)
LOAD MatchNumber, Date, VisitorTeam as Team, VisitorGoals as Goals, 'Visitor' as HomeVisitor
FROM ...