-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$

1 Answer 1

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
    Commented Sep 19, 2017 at 7:33

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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