Rafael Barros 2 Posted July 12 Share Posted July 12 I love the data cleaning and wrangling features in Spotfire 😍 But sometimes, 😅 I really miss the "Remove duplicated rows" transformation option. Link to comment Share on other sites More sharing options...
David Boot-Olazabal Posted July 12 Share Posted July 12 Hi Rafael, You are not the only one, see also this enhancement request: https://ideas.spotfire.com/ideas/TS-I-6076. There is also a suggestion added to the request, and that is to use a single match and/or treat null as equal options when joining two tables. Kind regards, David Link to comment Share on other sites More sharing options...
Olivier Keugue Tadaa Posted July 12 Share Posted July 12 (edited) Hi Rafael, There is a workaround with the "Pivot" You will first need to identify some key columns, then secondly, for the remaining ones, use the max/min/unique-concatenate, etc as aggregation methods. and finally %V as the naming pattern like in the example below Edited July 12 by Olivier Keugue Tadaa Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now