Find Replace (Append fields) not working as required

[Inactive User]

Hi community,

I have two table Tab1,Tab2. Trying to perform lookup like excel,mean want first occurance of value against each lookup value in Tab1.

Tab 1

Id  Value

1      A

1      B

1      C

1      D

2      E

2      F

2      G

2      H

Tab2

Id  Value(currently getting)    required output(against id)

1      D                                                      A  

1      D                                                      A

2      H                                                      E

2      H                                                      E

Can anyone help !

Thanks in advance.

[IraWatt · Accepted solution]

Hey @Inactive User,

The easy way to do a VLookup is with a sample tool and join:

The sample tool gets the first value for each ID then you can just join on that:

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com 

[Inactive User]

Thanks @IraWatt for reply, can we do something in find replace tool to achieve this, because my workflow is large there is too much dependency on multiple fields, So it may effect the result of another fields if i change it like this.

[FrederikE]

Hey @Inactive User,

Is the data sorted the correct way? Since from what you described a Find&Replace should do the job. Maybe sorting at the beginning is all you need to do. 

But what @IraWatt wrote should work, no matter how big your workflow is, as it's not applying any other changes then a Find & Replace. 

[Inactive User]

Thanks @FrederikE,@IraWatt this worked for me.

[IraWatt]

@Inactive User sure here is the same approach using find and replace: