openmolecules.org Forum: Functionality

Home » DataWarrior » Functionality » Renaming column

Show: Today's Messages :: Polls :: Message Navigator

Re: Renaming column [message #2248 is a reply to message #2242]

Mon, 22 July 2024 17:15

thomas
Messages: 715
Registered: June 2014

Senior Member

Columns cannot be renamed, because the original column name is used in many places to refer to a column. You can add an alias, though. This causes to display the alias instead of the original column name.

Currently, you cannot set column alias defined by a mapping file. But maybe you can do one of these as a workaround:
- define target column names in the SQL statement as: SELECT user_id ID, user_name Name FROM ...
- run a macro (dwam) or apply a template (dwat) to define aliases for you dwar document

Report message to a moderator

[Message index]

		Renaming column By: slprakash on Mon, 22 July 2024 14:48
		Re: Renaming column By: thomas on Mon, 22 July 2024 17:15
		Re: Renaming column By: slprakash on Thu, 22 August 2024 13:07
		Re: Renaming column By: yuan on Mon, 12 August 2024 04:17

Previous Topic:	Use label in Form Table
Next Topic:	chemical complexity calculation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri Nov 22 03:26:18 CET 2024

Total time taken to generate the page: 0.03837 seconds