Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I am looking to identify an opponents Team Name by looking at current data in the csv
I have used ''Filename() as Clientname'' in the script to identify my client teams name
My clients Team Name (e.g Team 1) and Opponent Name (e.g Team A) appears in both fields depending on which team is Pitching
I need to to identify that Team A is the Opponent Teams Name (i.e the Team Name that does not equal Clientname)
In the .csv file, the data appears as follows
Pitching Team,Hitting Team
Team 1,Team A
Team 1, Team A
Team 1,Team A
Team 1, Team A
Team 1,Team A
Team 1, Team A
Team A,Team 1
Team A, Team 1
Team A,Team 1
Team A, Team 1
Team A,Team 1
Team A, Team 1
Maybe something like
LOAD *,
If( ClientName = [Pitching Team],[Hitting Team], [Pitching Team]) AS Opponent;
LOAD [Pitching Team],[Hitting Team], Subfield(Filename(),'.',1) as Clientname
FROM 'Team 1.csv';
Hi,
Can you please explain in detail.
From the above details I understand that, we need to identify opponent team for each team.
In that case, it is Qlikview's basic ability to map and result the relevant fields
Thanks.
Are you trying to set two variables with client name team and opponent team? Where exactly do you need this information?
Hi kevin,
Can you explain better the problem or upload the project?
Regards
Maybe something like
LOAD *,
If( ClientName = [Pitching Team],[Hitting Team], [Pitching Team]) AS Opponent;
LOAD [Pitching Team],[Hitting Team], Subfield(Filename(),'.',1) as Clientname
FROM 'Team 1.csv';
Thank you for the correct answer