SOLVED
Removing Mirrored Duplicates
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
sgibson34
5 - Atom
‎06-25-2024
05:34 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
My data has quite a few instances where the rows are duplicate, but the values are just mirrored in different columns. I want to remove the duplicate instance and keep the original. For example, if row1 = x y and row2 = y x I want to get rid of the second row but keep the first.
Solved! Go to Solution.
Labels:
- Labels:
- Developer Tools
3 REPLIES 3
Raj
16 - Nebula
‎06-25-2024
05:48 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@sgibson34
find the workflow attached
mark done if solved.
‎06-25-2024
05:54 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I could use this if i could concatenate the data from the two columns together, how would i do that?
Raj
16 - Nebula
‎06-25-2024
06:37 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@sgibson34 find the updated workflow
mark done if solved.
