topic Help Needed with joining fields in one table with another in QlikView

Help Needed with joining fields in one table with another

Fri, 01 Jun 2012 13:42:51 GMT

Hello All,

I am new to QlikView and have an issue...

I need to force join the "Year" and "Period" from the FPPS table with the Load Incline table I created 'New YPQ Table'

FPPS:

LOAD Year,

Period,

[FPPS customer],

Material,

[FPPS Material desc],

[FPPS line item],

data

FROM

[Qlikview_FPPS Ger mkt_v2.xlsx]

(ooxml, embedded labels, table is [Qlikview_FPPS Ger mkt 2010]);

New_YPQ_Table:

LOAD F1,

[Metrics],

Year,

Period,

Quarter

FROM

[..\..\..\Book1.xlsx]

(ooxml, embedded labels, table is Sheet1);

Any help would be appreciated!!!!

Help Needed with joining fields in one table with another

Fri, 01 Jun 2012 15:33:13 GMT

Make a custom Key to join it, for example

FPPS:

LOAD [Year] & '_' & [Period] as KeyYP,

Year as [Year FPPS],

Period as [Period FPPS],

[FPPS customer],

Material,

[FPPS Material desc],

[FPPS line item],

data

FROM

[Qlikview_FPPS Ger mkt_v2.xlsx]

(ooxml, embedded labels, table is [Qlikview_FPPS Ger mkt 2010]);

New_YPQ_Table:

LOAD [Year] & '_' & [Period] as KeyYP,

F1,

[Metrics],

Year as [Year YPQ],

Period as [Period YPQ],

Quarter

FROM

[..\..\..\Book1.xlsx]

(ooxml, embedded labels, table is Sheet1);

Hope it helps.

Help Needed with joining fields in one table with another

Thu, 07 Jun 2012 09:14:42 GMT

Thank you very much Juan for your help, its much appreciated and fixed my issue