Column2= IF Contains(column1,"cat") OR Contains(column1,"cats") OR Contains(column1,"Cat") THEN Cat END
Or You can Group Them as Cat Group
Thanks for your reply! But there are thousands of rows, and the data source is dynamic, so I can't do every situation. I wonder if there is a function in tableau that could do inaccurate match, or find the most similar string?