2 Replies Latest reply: Jun 7, 2012 5:14 AM by yusufkhan0000 RSS

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