topic Re: Linking Issue Between Tables in QlikView

Linking Issue Between Tables

vanderson009 — Tue, 17 Dec 2013 03:35:03 GMT

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.....

Re: Linking Issue Between Tables

ramkrishna86 — Tue, 17 Dec 2013 05:36:53 GMT

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

Re: Linking Issue Between Tables

Anonymous — Tue, 17 Dec 2013 05:43:11 GMT

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

Re: Linking Issue Between Tables

qlikpahadi07 — Tue, 17 Dec 2013 06:20:21 GMT

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$);