Find Replace (Append fields) not working as required

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

2 H E

Can anyone help !

Thanks in advance.

Output

Accepted answers

IraWatt

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

Workflow.yxmd

All comments

IraWatt

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

Workflow.yxmd

unknown

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.

unknown

Thanks @FrederikE,@IraWatt this worked for me.

IraWatt

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

Workflow.yxmd

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335