Find Replace Tool

[RichardAlt]

Hi All,

I'm creating a workflow with Find Replace Tool,

My problem is my data have multiple same values.

For Example: Find Value (Description 1)

Description1	WA
CLEWVGISDOAP01	130
CLEWVGISDOAP01	4053
CLEWVGISDOAP01	6837

For Example: Find Within Field (Description 1)

Description1

CLEWVGISDOAP01

Append WA.

The output is this.

Description1	WA
CLEWVGISDOAP01	6837

But my desired output is this.

Description1	WA
CLEWVGISDOAP01	130

[afv2688]

Hello @RichardAlt ,

Is there some kind of rule that could help us filter out the other two values?

Regards

[afv2688 · Accepted solution]

For example,

Here I'm applying the condition to take the lowest value:

Regards

[RichardAlt]

Hi @afv2688, 

Thank you! It worked, but I don't know if this a long-term solution. Because every month has different data.