I'm bringing in a series of Excel Spreadsheets into a Qlikview document but the spreadsheets don't have a date column. I would like to add a date column but it needs to reflect the name of each workbook. So, I have files called - "Info WC 01-04-16", "Info WC 08-04-16", "Info WC 15-04-16" and so on. It's the WC date I need to create. An added complication is that I concatenate each new file on a weekly basis, so I'm just looking for the newest file in the folder and adding it the bottom of the current data.
