I am facing the challenge of changing a column in our data warehouse which affects one tableau data source which then affects multiple reports.
If I rename the column, the report itself claims that this column does not exist any more spits out an error. Having multiple reports attached to this data source would imply that I need to open up all the reports and change them manually.
+----------+----------+-----------+----------------+----------+
| column 1 | column 2 | change -> | column renamed | column 2 |
+----------+----------+ +----------------+----------+
| data 1 | data 1 | | data 1 | data 1 |
+----------+----------+ +----------------+----------+
| data 2 | data 2 | | data 2 | data 2 |
+----------+----------+ +----------------+----------+
| data 3 | data 3 | | data 3 | data 3 |
+----------+----------+-----------+----------------+----------+
Is there a smart way of doing a column rename without changing all the reports?