Forum Discussion
Add column based on row
Hi, I want to add a column based on row 1 below: so that I end up with a table with the following headers: Local name Person ID Gender Age Postcode Test 1 EXAMPLE001 Female...
The situation is that I am setting up an system where files will be uploaded to a folder monthly. The files will come from different companies.
I will then have to combine the files in order to create a report, therefore i need to know which company the file is coming from.
Try to give for each file the name of the company (providing the data), and using the combine feature you will have a column with the name of the company (coming from the filename) will be added.
The issue with using the file name or Source.name is that it will vary each month and not necessarily give the name of the company
Can you give an example of two or 3 files so I can understand the logic behin?