General Discussions
Discuss any topics that are not product-specific here.
hello! how can we remove duplicates that are caused from concatenating, it doesn't occur in every row. below is an example of what is happening.
Hey @sericson, I'd split out the values, leverage the Unique tool to get rid of duplicates and then re-concatenate those left. The other tools such as the Sorts and Tile are just ensuring everything stays in the original order. Here's an example of the start end end result:
