Lookup Help

Hi everyone !

I wonder if anyone could help - I need to manipulate some data between two data tables - in Table #1 one of the columns is "Serial Number" and in table #2 I have "Serial Number" linked to "Customer Code" - I would like to look up the "Serial Number" and return the "Customer Code" in a separate column in my Table #1.

I tried using the Find Replace functionality but I think that would replace the Serial Number value in my intial table ? Is there a way to do the lookup and populate a different column in my original table ?

Thanks for any help !

Chris

Datasets

Accepted answers

ChrisMcN

Thanks - after a little manipulation that worked ! I really appreciate the help ...

All comments

JosephSerpis

Hi @ChrisMcN you can use a join tool and it would through the J output return all the values from Table 1 that match Table 2 and output customer code.

rkapoor

@ChrisMcN

You can derive the customer code by using the Append configuration in the Find/Replace tool.

Have a look at the attached sample workflow.

chrismcn_sample.yxmd

CarlDi

instead of selecting the 'Replace Found Text with Value:' radio button, you can select "Append Field(s) to Record:" - this will prevent it from overwriting the content in your columns.

ChrisMcN

Thanks - after a little manipulation that worked ! I really appreciate the help ...

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703