topic Re: For loop Problem in QlikView

For loop Problem

Sat, 03 May 2014 17:24:44 GMT

Hi

PFA

Re: For loop Problem

jagan — Sat, 03 May 2014 17:42:18 GMT

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.