topic Re: Multiple file load from server location in QlikView

Multiple file load from server location

Thu, 21 Feb 2013 09:35:52 GMT

Hello,

I need to load some data into QV from Visual Fox. Using the file name, I need to create 2 columns in that table, one with month and one with year. Since records go back for about 8-9 years, is is possible to load every file from that folder that starts with "DetaliiTichete....."? The plot thickens since I have to do this for all of 47 servers, but I'm sure that if I manage to make it work for 1 of them, I'll get all of the data and concatenate it after.

Any ideas?

Thanks

Re: Multiple file load from server location

Thu, 21 Feb 2013 09:54:48 GMT

Hello,

Generally in Qlikview you can load multiple files using '*'.

In you case

Load * FROM path/DetaliiTichete*;

Regards,

Yaseen

Re: Multiple file load from server location

Thu, 21 Feb 2013 10:36:13 GMT

Thank you for your response Yaseen. I think it works like that, but how do I manage to do this using an OLE DB connection?

After the connect statement, how would the code look like if the path is '\\192.168.200.30\datab$\NOMEN' ?

Re: Multiple file load from server location

Fri, 01 Mar 2013 08:18:05 GMT

Managed to do it. Here is what i used:

For each vFile in FileList('t:\CONTABILITATE\Detaliutichete*.dbf')

$(vFile):

SQL SELECT *

FROM $(vFile);

next vFile;