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...
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?