Spotfire Ideas Portal
Problem
Files need to have fixed names and this is not always the case, files can have a date or time indication in their file name. Especially with log files or periodically created files.
Possible solution
Option to read the files in a folder passed on a pattern, for instance:
* |
reads all files in the folder |
*.csv |
only csv |
*2020.csv |
everything ending on 2020 and is a csv |
*JAN*.csv |
every file containing JAN and that is a csv |
The files will then be combined in one table with an identification of the source file, just like the add rows process.
I know this can also be achieved with Python or R but it would be good to have this available for the entry level user.
Thanks for a great idea Bart! This relates to support for new file locations and file types.