I am curious if there is any way to include the filename or part of a filename for CSV files in the base view; something simlar to how the Excel wrapper can provide the sheetname as a column in the base view for an Excel data source.
My use case scenario involves using querying for data in multiple CSV files that have the same format. One of our ETL processes creates a CSV file everyday with the timestamp string in the filename in a folder. The information contained in the CSV file represents a snapshot of particular pieces of information. However, a date column is not present in this CSV file and for various reasons we cannot introduce a timestamp column in the CSV file.
As these filenames follow a certain pattern I have been able to create a CSV data source (via SFTP) with the file name pattern so that it can pick up multiple files in the folder. What I am hoping to do is somehow have filename or the timestamp portion of the filename as a separate column in the base view for the data source.
Here is an example of what I am trying to do:
**Expected Base View**
| FileName | Col1 | Col2 | Col3 |
| -------- | -------- | -------- | -------- |
| SampleCSV.20170101.csv | r111 | r112 | r113 |
| SampleCSV.20170101.csv | r121 | r122 | r123 |
| SampleCSV.20170102.csv | r211 | r212 | r213 |
| SampleCSV.20170102.csv | r221 | r222 | r223 |
I am not an admin on our enterprise instance. So I am limited by what I can do in the VDP. I am looking for something that comes as close as possible to an out-of-the-box solution. That being said if this absolutely requires a custom wrapper I can make that happen with the admins.