-1
$\begingroup$

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.

$\endgroup$
0
$\begingroup$

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,

$\endgroup$
1
  • $\begingroup$ Unfortunately I don't know nor have python pandas. $\endgroup$
    – ZeiH
    Sep 19 '17 at 7:33

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.