Joining columns from different datasets

[tomtingley]

Hi,

I have two input files (attached).

The file "ID" has the 'Property ID' and the Building associated with that ID.

The file "Combined" only has Building.

I want to create a new column in the "Combined" file called "Property ID" from the "ID" Input.

For example,

Right now in "Combined" file I have "Property".

In "ID" file I have "Property" and "Property ID".

I want "Property" and "Property ID" columns to be in the Combined" file.

[ShankerV]

Hi @tomtingley 

One way of doing this.

Many thanks

Shanker V

[ShankerV]

Hi @tomtingley 

Step  1: Input both files.

Step 2: 

Step 3:

Step 4:

The combined file now gets the Property ID.

Hope this helps!!!!

Many thanks

Shanker V

[binu_acs]

@tomtingley Find and Replace tool is another option