IsNull replacement with lookup

[Bob]

Hi, I did lookup of data from a mapping file using Find Replace Tool. After that, the column has few blanks. For those blanks, I want to perform lookup again from the same mapping file based on a certain criteria. (similar to iferror(vlookup()) in Excel). Is there any tool that can be used to do this kind of advanced data cleansing with customisation? Appreciate any guidance!

Thank you!

[messi007]

@Bob,

You can filter the null values and performe the cutomisation and from there you can use a union with the output of the find and replace tool.

If you can share a sample data with what you expect to have we can help you.

Regards,