topic Re: How to Reload Data...... in QlikView

How to Reload Data......

alvinford — Fri, 29 Mar 2013 17:48:39 GMT

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.

Re: How to Reload Data......

Gysbert_Wassenaar — Fri, 29 Mar 2013 19:21:30 GMT

See attached qvw.

Re: How to Reload Data......

alvinford — Sat, 30 Mar 2013 02:38:36 GMT

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.

Re: How to Reload Data......

Sat, 30 Mar 2013 09:25:32 GMT

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$);

Re: How to Reload Data......

Gysbert_Wassenaar — Sat, 30 Mar 2013 09:28:24 GMT

Change

LOAD *, '$(FoundFile)' as SourceFile

into

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

Re: How to Reload Data......

alvinford — Sat, 30 Mar 2013 16:17:50 GMT

Hi Gesbert,

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

Regards,

Alvin.