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.

[Garabujo7]

Hello @Raj008 by assign you mean?, concatenate the values or how would you assign the plant to a description?

Could you elaborate some more about that.