LOOK UP VALUE

[Johmz]

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 2

[DavidSkaife · Accepted solution]

Hi @Johmz 

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

[Johmz]

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

[DavidSkaife]

Hi @Johmz 

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

[Johmz]

Thanks David for all the recommend solution.