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,