Leauge match Display

[#1]

Hi,

I have excel sheet with two tabs.

Team sheet have all team which are participating.

League sheet have league matches with opponent.

Now I want to display league sheet by selecting list box

for example

if I select  WAKFIELD or PETERBORUGH from List box it supposed to show me data from League sheet.

Regards

Vinay

[hic · Accepted solution]

League:

LOAD RecNo() as GameID,

   Team1,

   Goal as Goal1,

   Team2,

   Goal1 as Goal2

FROM Team.xlsx (ooxml, embedded labels, table is League);

Teams:

Load GameID,

   Team1 as Team

   Resident League;

Load GameID,

   Team2 as Team

   Resident League;

It is in fact very similar to a Canonical Date, although it concerns teams and not dates.

HIC

[MK_QSL]

May be like this...

TEAM:

LOAD Teams as Team1

FROM

Team.xlsx

(ooxml, embedded labels, table is Team);

TABLE1:

LOAD Team1,

     Goal,

     Team2,

     Goal1

FROM

Team.xlsx

(ooxml, embedded labels, table is League);

Concatenate

LOAD Team1 as Team2,

     Goal as Goal1,

     Team2 as Team1,

     Goal1 as Goal

FROM

Team.xlsx

(ooxml, embedded labels, table is League);

[#4]

Thanks Henric & Manish. Its work. I appreciated your help.

Thanks

Vinay