-
1. Re: Rename field/column headers using another table
Eddson Sierra Jun 11, 2018 12:40 PM (in response to Greg Useem)Hi Greg,
Did you already try to edit the alias for each member of the field?
Create Aliases to Rename Members in the View
Best,
-
2. Re: Rename field/column headers using another table
Greg Useem Jun 11, 2018 12:43 PM (in response to Eddson Sierra)Thanks! Because there are so many fields I was hoping to do this as a join instead of typing each one in. Thoughts?
-
3. Re: Rename field/column headers using another table
Michael Gillespie Jun 11, 2018 1:06 PM (in response to Greg Useem)Greg, can you not get the result you want by doing a left join in the data source tab? I think that's how I've done it with ACS data in the past.
Do you have 2 separate workbooks or 2 sheets in the same workbook? I seem to recall that the ACS data comes out as CSV files but is there an option to output an xls instead?
If the join doesn't work, can you do a blend in the worksheet instead?
-
4. Re: Rename field/column headers using another table
Greg Useem Jun 11, 2018 2:11 PM (in response to Michael Gillespie)Yes, that would work if I pivoted the data. I was wondering if there was a way to not pivot the data and use a join (or a different function) to alias the column headers/field names.
Right now my data looks something like this:
Table 1.
Hc01EstVc01
Hc02EstVc01
Hc03EstVc01
Hc04EstVc01
Table 2.
Hc01EstVc01
Housing costs
Hc02EstVc01
Location
Hc03EstVc01
Number of units
-
5. Re: Rename field/column headers using another table
Eddson Sierra Jun 14, 2018 7:21 AM (in response to Greg Useem)What about a blending? And you could use a equivalence table.
-
6. Re: Rename field/column headers using another table
Greg Useem Jun 18, 2018 10:19 AM (in response to Eddson Sierra)How would you use that to rename the column fields?