Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hello,
Generally in Qlikview you can load multiple files using '*'.
In you case
Load * FROM path/DetaliiTichete*;
Regards,
Yaseen
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' ?
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;