Forum Discussion
Is it possible to import parameterised .csvs from a folder? Query not possible with File.Contents!
Hi all first post here...I'm very much a noob so I apologise in advance if my query is overly basic. I've spent the last couple of days searching online for a solution but can't seem to find one. ...
If you can predict the full filenames, you could dynamically generate them in your query as a single-column table, and then make a custom column with File.Contents and concatenate the new filenames with the folder path. Can you give an example of a few full filenames? Are they predictable? Or have random characters?
Pat
Hi mahoneypat
sure thing...yep, the filenames are static bar the date so they are easy to define. I've created (I think) a table as you have suggested with the filepath and filenames....