Forum Discussion
Column name reverting after data refresh
Ohh that is a new one!
Things to try:
- If you right click the table and choose show Hidden in report view, do you have two Title/Project Name
- When you hover over the field in the Data pane does it show the original name?
- Can you take a screen shop of your queries and the M of the final step
- If you duplicate the column in the query editor do both get brought through?
Ah - forgot to add that I tried to view hidden. Unfortunately no cigar.
Hovering over the data pane on "Title" (pre refresh) this is what it shows:
And then post refresh:
Here are the steps for the Master Project List query:
Worth noting, I also started rebuilding this query from scratch to see if renaming and merging etc was causing issues. When renamed columns in "Master Project list (2)" the same issue persists:
Here I've made a duplicate of Project Name --
...and it just comes through as "Title 2"
HI nlovoldegar
Daft question but you haven't been editing the M under Advanced editor have you?
It is possibel to change the very last bit IN #"your last step" to be point at another step IN #"A step further up" and it wont show you this in the front end.
I just went in and re-wrote the query so all renaming happens at the end. Still same issue after applying the query: