Discussion Board for collaboration related to QlikView App Development.
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!!!!
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.
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.
Thank you very much Juan for your help, its much appreciated and fixed my issue