For loop Problem

[#1]

Hi

PFA

[jagan · Accepted solution]

Hi,

Please find script below

FOR i = 1 to Month(Today()) -1

  LET vMonthYear = Text(Date(MakeDate(Year(Today()), i), 'MMM YYYY'));

  If i = 1 then

  Data:

  LOAD organizationLookupDesc,

      corporateFunctionLookupDesc,

      employeeRootId,

      lastName,

      firstName,

      '$(vMonthYear)' AS SheetName    

  FROM

  [EMEA HEADCOUNT 2014_GMBH-Anonym.xlsx]

  (ooxml, embedded labels, table is '$(vMonthYear)');

  ELSE

  Concatenate(Data)

  LOAD organizationLookupDesc,

      corporateFunctionLookupDesc,

      employeeRootId,

      lastName,

      firstName,

      '$(vMonthYear)' AS SheetName      

  FROM

  [EMEA HEADCOUNT 2014_GMBH-Anonym.xlsx]

  (ooxml, embedded labels, table is '$(vMonthYear)');

  ENDIF

NEXT

Regards,

Jagan.