Import of Multiple Files
Data is easily imported by drag-and-drop in LEANalyser, but how should you do if you wish to import an entire folder or files with a name meeting a specific criteria to one single table?
It is very easy, you just need to edit the file path which indicates the place to import the file from and know that the wild card character to use is: *.
For instance, if you wish to import all files starting with “Orders 20” from the Orders folder, you set the file path to /Users/Doe/Projects/Orders/Orders 20*. If there are orders from several years in separate files, let’s say 2017, 2018 and 2019, they will all be imported into one table. If automatic reload has been activated in Prepare mode, all new order files meeting the given criteria will meanwhile be added to the table.