I have 10+ different fields. Each field has multiple duplicates separated by a semicolon in the cell. How do I remove the duplicates in all fields using the fewest tools possible? Thank you!
Solved! Go to Solution.
Hi @htalteryx
You can remove the duplicates using a Unique tool. Select the proper fields in the Unique tool that contains the duplicates.
https://help.alteryx.com/20223/designer/unique-tool
@htalteryx
I dont see how I can use the Formula tool here.
You mentioned that have multiple columns containing duplicated data so typically we can use a Transpose tool to bring the column data to one column.
Then do a parse with your specified delimeter, in your sample data, we assum it is , and ;.
After that, we can then use a Unique tool and bring the data data back to original form with Cross Tab.
@htalteryx , Here is another way to do this with 4 tools if you have Primary key already in your data.
Hi All,
I figured out how to do it with one formula tool:
REGEX_Replace([Manager], '(\b[^;]+)(?=.*; *\1(?:;|$)); *', '')
Thanks anyways!
Thanks for the discussion!