Forum

Renaming columns us...
 
Notifications
Clear all

Renaming columns using data in query columns

3 Posts
2 Users
0 Reactions
170 Views
(@sal-veltri)
Posts: 27
Eminent Member
Topic starter
 

I have a query in the correct format but need some column names changed. It can be done manually, but I'd like to do it automatically.  Attached are two screenshots, one with no header, the other has header names that were manually entered.

 

The query is of two 18 hole golf courses, that contains hole information (Par, hole handicap (both men and women)) for each course. Having the course name in a separate column, I want to arrive at naming the columns as demonstrated in the second screenshot

Here is the link to see the screenshots:   https://www.dropbox.com/sh/x9ns177mmjcn25m/AAB5BkzTzWuGFm1wS-1NY-Rqa?dl=0

 
Posted : 17/06/2019 12:14 am
(@mynda)
Posts: 4761
Member Admin
 

Hi Sal,

Please see attached. Note: I had to recreate your file so the figures are random and won't match yours, but you should still get the ideal.

Mynda

 
Posted : 17/06/2019 7:32 am
(@sal-veltri)
Posts: 27
Eminent Member
Topic starter
 

Hi Mynda,

Very helpful, thank you.

Sal

 
Posted : 17/06/2019 5:15 pm
Share: