How to change column names to be able to properly use the Join function

[esabay]

Hi All,

I have two input files: one for the names and money owed and the other one is for the names and email addresses. How can I rename the cust_name from table to so I can use the Join function properly. Thank you for the help

Table 1				Table 2
Legal Name	Money Owed			cust_name	cust_contact
Sam	123			Sam	sam@email
Ram	456			Ram	ram@mail
Tango	789			Tango	tango@mail
Ueclid	999			Ueclid	u@email
Varus	111			Varus	varus@emai

[esabay]

How can I rename the cust_name from table 2 to so I can use the Join function properly. Thank you for the help** sorry for the typo error

[binuacs · Accepted solution]

@esabay You can join both fields without renaming, once join if you want to rename any of the fields you can change it in the join tool

[nagakavyasri · Accepted solution]

You can Join by position or by specific fields and then rename:

[esabay]

Thank you both appreciate the help