Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Help Needed with joining fields in one table with another

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

Tags (2)
1 Solution

Accepted Solutions
Not applicable

Help Needed with joining fields in one table with another

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.

View solution in original post

2 Replies
Not applicable

Help Needed with joining fields in one table with another

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.

View solution in original post

Not applicable

Help Needed with joining fields in one table with another

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