Multiple Search Columns for Find and Replace

[Sanjay_TVA]

Hi All,

I have to standardize Indian address ,So I'm having a postal lookup from there i will match up with my source address column and parse it into different columns (such as village name,taluk,post office) using Find and Replace (Append Method)  so if that record is in lookup it will be added else it will be null.

After that i have to use several joins to validate the integrity of data i.e whether that village is in that particular pincode or not .

This takes up huge amount of tools and memory, If it is possible

1.Can we lookup using multiple find conditions (City Name,taluk,village name,Post office,State Name) in a single find and replace tool?

2.Any other tool/logic suggestions to get the valid data?

  

[messi007]

@Sanjay_TVA,

You can use batch macro in order to batch on find and Replace and join tools:

Below a link for batch macro.

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Getting-Started-with-Batch-Macros/t... 

Hope that helps,

Regards,