Tableau: How to change multiple field names

-1

From SQL server I imported multiple tables that each have multiple fields. Unfortunately the field names are not that descriptive (data is originally from SAP) but I have a separate Excel file that has description for all the field names.

Is there a way how I could rename multiple fields once by using the Excel file? Renaming them one by one would be too slow way to do it.

ZeiH

Posted 2017-09-18T14:35:13.653

Reputation: 1

Answers

0

Do you have/know python pandas? An easy why would be too load it into pandas and do the modifications there.

df= pd.read(excel)

AFTER Comment

OR:

You can rename columns in SQL with AS - if that is possible with your SAP import. To create a (semi-) automated Logic should be easy with a decent Texteditor,

El Burro

Posted 2017-09-18T14:35:13.653

Reputation: 690

Unfortunately I don't know nor have python pandas. – ZeiH – 2017-09-19T07:33:13.217