Team, I have fields as follows:
Input File 1:
Type | Description |
HA | Hello |
Input File 2:
Type Code | Doc Type |
HA 01234 | Hello |
I would like to use the "FindReplcae" tool and use "HA" from Input file 2 as the Lookup value and find that in Input File 1 and get the Description value as "Hello" in the "Doc Type" field.
Please help, thanks in advance.
Solved! Go to Solution.
Hi @OllieClarke , a few of the parameters like "IN" & "KR" and some more may not be available, whatever is matching and found, only for them, the data must be populated, else, it must remain NULL.
@cjaneczko, thank you for this, even though I have used a similar approach for this (screenshot attached for your reference). But I was looking for any other easiest approach. Thank you so much once again.