Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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 namePerson IDGenderAgePostcode
Test 1EXAMPLE001Female76XX00 0XX
Test 1............
Test 1............

 

How do I do this?

 

Thanks

Need Help

5 Replies

  • AmiraBedh's avatar
    AmiraBedh
    Super User
    3 years ago

    Can you please elaborate more the logic behind adding this row ?

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      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.

      • AmiraBedh's avatar
        AmiraBedh
        Super User
        3 years ago

        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.