Loop issue

sumanta12 — Sat, 16 Nov 2024 18:13:15 GMT

Hi All,

I have a data like below:

Now I want to load data for each date and store it in each qvd and I have written the below script:

TMP_TABLE:
LOAD
DATE(Date,'DD-MMM-YYYY') AS Date,
Name
FROM
[C:\Users\smandal\Downloads\Test.xls]
(biff, embedded labels, table is Worksheet$);

FOR i =0 TO (NOOFROWS('TMP_TABLE')-1)

LET v_data = PEEK('Date',i,'TMP_TABLE');

NOCONCATENATE
TABLE:
LOAD * RESIDENT TMP_TABLE
WHERE Date = '$(v_data)';

STORE TABLE INTO C:\Users\smandal\Downloads\$(v_data)_TEST.QVD(QVD);

NEXT i

But it is not working. The code is generating qvd from 17-Aug-2020 to 31-Aug-2020 but data in the qvd is same for all.

Please help.

Re: Loop issue

Kushal_Chawda — Mon, 17 Aug 2020 12:44:35 GMT

try below

TMP_TABLE:
LOAD distinct
floor((Date) AS Date,
Name
FROM
[C:\Users\smandal\Downloads\Test.xls]
(biff, embedded labels, table is Worksheet$);

FOR i =0 TO (NOOFROWS('TMP_TABLE')-1)

LET v_data = PEEK('Date',i,'TMP_TABLE');

LET v_data_format = date(PEEK('Date',i,'TMP_TABLE'),'DD-MMM-YYYY');

NOCONCATENATE
TABLE:
LOAD * RESIDENT TMP_TABLE
WHERE floor(Date) = '$(v_data)';

STORE TABLE INTO C:\Users\smandal\Downloads\$(v_data_format)_TEST.QVD(QVD);

DROP Table TABLE;

NEXT i