The new enhanced TimeXtender connectors for CSV and Excel allow aggregation of similarly structured files.
We need an additional field when loading aggregated files: the URI (full path and filename) so we know where each record is coming from. Sample use case: If filenames contain the date of the file, the latest file’s records can be found by parsing the URI.
On that note, it would also be nice with a row number field. For aggregations, it should restart at 1 when a new file is loaded. DW_Id might (?) be OK for single files but it’ll be a bit finicky for aggregated files.
