This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
My final goal is to apply fuzzy matching to different cities within countries. There are 183 countries in total, and quite a few countries have cities with the same name, so I would like to do it in a loop, applying fuzzy matching for each country separately. I believe I am supposed to be using iterative macro but so far I cannot figure out how.
My idea was a simple loop through values 1 to 183, then for each iteration I would only keep the country which id matches the iteration number, do the fuzzy matching, then somehow output, so that in the end all of the results stuck up together. Should the fuzzy matching be inside the macro, or macro would just loop through the numbers?
I am also confused about the macro input: in the beginning I thought it will loop through whatever I specified in the tex/file input, so I just created a file with a column of numbers from 1 to 183, but I guess that's not the way...And if we already did specify the tex/file input, why when I insert the macro in the actual workflow it again requires the left hand input? doesn't it have the data already? I am confused. Please, help.
You can do this more easily with a Batch Macro. A good way to think about these two macro types are that Batch macros apply the same logic to subsections of data, while iterative macros allows you to reuse records multiple times.