I have a file with account names which I wish to group into larger account groups.
The sample data shows the problem. The Account names need to be grouped into Account groups. The second table shows the mapping. The idea is to see if the Account Name contains the lookup string, and if it does put the Account name next to this record.
I can do this by using a formula and the Contains function e.g.
If Contains([Account Name], "Auto",1)
then "Automotive"
else [Account Name]
endif
but this means manually creating this function hundreds of times (there are these many groups), and it will be very difficult to update at future iterations.
Can I do this with Alteryx by automating it somehow? Any tips on how to do this? Any questions happy to clarify.
