Assigning the right value

Raj008

Hi All,

I have a table as given below

Plant Description	Plant
Electric	Plant 1
OS50	Plant 2
HP2	Plant 3

My requirement is, I will get the Plant Description in a file with other fields and I need to assign the Plant to it. How to go about it?

Luke_C

Hi @Raj008 

There are two approaches:

1. Use the find and replace tool's append functionality:
   1. Main data set goes into the F anchor, the table you provided goes to the R anchor.
   2. Select the two description fields
   3. Select the 'append fields' radio button and select the plant field. 
   4. This will append the plant to each record based on the description. If it's not found it will be left null.
2. Use the Join tool
   1. Similar to the above, connect the two data sources and select the description fields to join on
   2. All matches will come out of the J output anchor, any that don't will be seen in L & R, which you could union back as needed.