How to Reload Data......

[alvinford]

Hi All,

I am encountering the following  reloading issue.

My folder structure is C:/Test/20130330/Semester1/Semester1.xls

                                C:/Test/20130330/Semester2/Semester2.xls

Want to reload the data on the daily basis from the above structure. The data will be from Semester1.xls and Semester2.xls (As example i gave one file there may be multiple excel files in each Semester1 and Semester2 folders) . The highlighted data in the above (20130330) represents date of the data. For every day a new folder with the date is maintained.

The issue is for daily reload I have to reload the Last three days data , example as we are in 30th the data has to be reloaded for 20130330,20130329 and 20130328 and store it in a QVD.

How to achieve this ? I have attached the sample data .. Test.zip

Thanks in Advance.

Regards,

Alvin.

[Gysbert_Wassenaar]

See attached qvw.

[alvinford]

Hi Gysbert...

Very thanks for your reply . The Logic wich you have given for .xls is correct . In other scenario I have to reload the data from the .log file and also fetch the data in the fixed record format i.e. for example

LOAD @1:n

FROM

C:\Test\20130329\Semester1\00.log

(fix, codepage is 1252);

Made necessary changes in the code. But when reloading the data the following error is displayed .Request your help to rectify this issue.

Attached the ZIP file for your reference.

Thanks in Advance...

Regards,

Alvin.

[#4]

Hey Alvin,

i highly regret for intervening into ur discussion

Hey Gysbert,

M having a different but .xls related querry,

m getting excel sheet on daily basis which have multiple sub sheets, i concatenate them and then use the data,

but due to limitations of xls sheet when the data exceeds it gets into new sheet i.e sheet2$ or sheet3$

how can i use that data without manually mentioning sheet3$

m looking out for this solution from a very long time

LOAD *,

'AL' as Prod_Grp,

'NCRC' as Prod,

'RCL' as Comp,

'$(vDay)  $(vMonth)  $(vYear)' as D_Date

  FROM

[\\10.65.8.83\d$\Data_dump\LTD_Dump_NCRC  $(vDay)  $(vMonth)  $(vYear).XLS]

(biff, embedded labels, table is Sheet1$);

Concatenate

LOAD *,

'AL' as Prod_Grp,

'UCRC' as Prod,

'RCL' as Comp,

'$(vDay)  $(vMonth)  $(vYear)' as D_Date

  FROM

[\\10.65.8.83\d$\Data_dump\LTD_Dump_NCRC  $(vDay)  $(vMonth)  $(vYear).XLS]

(biff, embedded labels, table is Sheet2$);

[Gysbert_Wassenaar · Accepted solution]

Change

     LOAD *, '$(FoundFile)' as SourceFile

into

     LOAD @1:n As LogEntry, '$(FoundFile)' as SourceFile

[alvinford]

Hi Gesbert,

Very thanks for your reply ... It works fine .... Cheers !!

Regards,

Alvin.