LOOK UP VALUE

I'm trying to use FIND REPLACE but its not working because both Loan ID and Acc ID column is missing/not reflecting in "FIND Within Field" and "Find Value" field of the FIND REPLACE configuration . I have two excel file to look up LOAN ID from Input1 to Input2, and add the STATUS column from Input2 to Input1.

Input 1

Input 1.PNG

Input 2

Input 2.PNG

Developer

Developer Tools

Designer Cloud

Accepted answers

Find Replace tool only works with String values - try converting both Loan ID and Acc ID to string and it should work

All comments

Find Replace tool only works with String values - try converting both Loan ID and Acc ID to string and it should work

But i have another problem. I need my output to reflect all status in different row if the Look up value has multiple status present in Input2

Try adding a Summerize tool on after Input 2 - group by Acc ID and concatenate Status, then Find Replace after that.

Thanks David for all the recommend solution.

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703