topic Re: Identify Opponents Team Name in QlikView

Identify Opponents Team Name

Wed, 17 Feb 2016 06:09:31 GMT

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

arasantorule — Thu, 18 Feb 2016 10:03:25 GMT

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.

sunny_talwar — Thu, 18 Feb 2016 10:55:29 GMT

Are you trying to set two variables with client name team and opponent team? Where exactly do you need this information?

sorrakis01 — Thu, 18 Feb 2016 11:19:43 GMT

Hi kevin,

Can you explain better the problem or upload the project?

Regards

swuehl — Thu, 18 Feb 2016 11:28:53 GMT

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';

Thu, 03 Mar 2016 05:15:17 GMT

Thank you for the correct answer