Linking Issue Between Tables

[vanderson009]

Hi Community,

PFA of Excel

I have this Excel Containing five sheets as five tables.

Tables are :- Series, Matches, BattingScorecard, BowlingScorecard, Teams

I knwo i need to create LinkTable between them but i dnt knwo how to

create linktable.

So please help me ragarding linktable issue.

- Regards,

Villyee.....

[ramkrishna86]

Concatenate all the sheet in your Excel Sheet to make a single table.

[Anonymous]

Hi Anderson,

Why Do you need to create a link table.

I think its not required,

You can easily map the fields between all tables.

If then also you want to create a link table.

Load the mapping fields only from each table and then concatenate all these table to get a single table then this resulting table can act as a link table and you can easily create a star schema.

Regards

Nitin

[qlikpahadi07]

Try This

QUALIFY*;

UNQUALIFY SeriesId;

Series:

LOAD SeriesId,

     [Series/Tournament],

     Season,

     Winner,

     Margin

FROM

ExcelData.xls

(biff, embedded labels, table is Series$);

Matches:

LOAD SeriesId,

     MatchId,

     Versus,

     Ground,

     MatchDate

FROM

ExcelData.xls

(biff, embedded labels, table is Matches$);

BattingScorecard:

LOAD SeriesId,

     MatchId,

     PlayerName,

     TeamId,

     Inning,

     Wickettaker,

     Runs,

     Balls,

     Fours,

     Sixes,

     SR,

     F12,

     F13,

     F14

FROM

ExcelData.xls

(biff, embedded labels, table is BattingScorecard$);

BowlingScorecard:

LOAD SeriesId,

     MatchId,

     PlayerName,

     TeamId,

     Overs,

     Medan,

     Runs,

     Wicket,

     Econ,

     F10,

     F11,

     F12

FROM

ExcelData.xls

(biff, embedded labels, table is BowlingScorecard$);

UNQUALIFY *;

Left Join(BowlingScorecard)

LOAD TeamId as BowlingScorecard.TeamId,

     TeamName as BowlingScorecard.TeamName

FROM

ExcelData.xls

(biff, embedded labels, table is Teams$);

Left Join(BattingScorecard)

LOAD TeamId as BattingScorecard.TeamId,

     TeamName as BattingScorecard.TeamName

FROM

ExcelData.xls

(biff, embedded labels, table is Teams$);