4 Replies Latest reply: Jul 15, 2015 3:53 PM by Виталий Чуприна RSS

    Join by two fields

    Виталий Чуприна

      I loaded NFR_MONTH_SHORT_NAME and NRF_WK_OF_MONTH from file name and then try to join it with NRFcalendar file. NRF calendar file contains following fields:

      Untitled.jpg

      WKDate:

      LOAD

        Month(Date#('$(MonthName2)','MMMM'))AS NFR_MONTH_SHORT_NAME,

        SubField(SubField(FileName(), ' ',-1 ),'.',1) AS NRF_WK_OF_MONTH

      FROM

      [$(vFile)]

      $(vLEXT);


      Left Join

      LOAD WKEND,

        NRF_MONTH_SHORT_NAME,

        NRF_WK_OF_MONTH,

           FISCAL_YEAR

      FROM

      [Z:\Test\Fiscal calendar.xlsx]

      (ooxml, embedded labels, table is Sheet1)

      WHERE FISCAL_YEAR = '2015';

       

      How can I return WKEND date from file.