Import every file from folder as data source

[Kamu Nv]

Hi all,

I have a folder full of txt files and I'd like to import all of them into a single data table in Spotfire. The problem is that there are too many of them to do it manually. They all have the same structure and name with diffetent dates.

For example:

Sourcefile_20200101

Sourcefile_20200102

etc...

Can you help me on how to do this

[Fabian Duerr]

Please check this discussion:

 

https://community.spotfire.com/questions/read-multiple-excel-files-same-format-same-folder

 

 

[Anders Gavare]

If you click on the + sign (Files and data), select "Browse local file...", and then select all the text files using shift-click or ctrl-click in the file selector dialog, then you should get to the "Add data to analysis" summary where it lists recommendations on what to do on import. If the files are considered similar enough, there should be a recommendation such as "Combine into a new data table".