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.
I have an interesting situation where I have a dataset that is between 150k and 250k items. For the most part, I will have a list that has generic names within the detailed name. While I TECHNICALLY could write a formula that says "if the column contains the parent name / naming convention name, then give it the parent / naming convention name" but I was curious. Is there a way that I can write up in a text input category a list of parents and naming conventions (see below) and reference if the name is contained in the naming convention, then the output is the naming convention?
The .yxzp file currently has a simple join but I dont believe there is a contains join. Has anyone ever run into this issue before?
I would add the NamingConvention as a new field (in the Find/Replace settings), then follow with a Select tool to unselect the original column and rename "NamingConvention" to the original column's name.