Hi everyone, I have a dissolve workflow in ArcGIS Pro that creates multi-part features (one row can hold multiple points, not constrained by lat,long fields)
Does anyone know if the Unique tool/Designer can remove duplicate points but also retain multi-points for some rows?
Solved! Go to Solution.
@JosephY are you able to attach some data/show a screenshot or anything? I'm not familiar with ArcGIS outputs but if the points are within different columns in each row, whilst I don't think you could directly check across each row, you could likely add a record ID to each, transpose (pivot) the table and use the unique tool on your points field - grouped by record ID - to remove duplicates.
Hi @DataNath, the first screen shot is removing duplicates and creating multipart features and the second is the output I would like to replicate in Alteryx. In the second screenshot the data is grouped as one data row because those are points categorized as within one hour time frames.
Oh yes, that's possible then! Here's an example from my own personal running data.
Beforehand - 162 coordinates, each in their own row (all belong to the same run):
Use a summarize tool on the 'Centroid' field and select 'Spatial' > 'Combine':
Outcome - All points combined into a single Multipoint, sitting in its own row:
If you have multiple time periods (like you say each MultiPoint will be a 1 hour timeframe), you can just set up a grouping ID for that and in the summarize tool group on that as well as conducting the combine.
Have attached my workflow for you to check out yourself as well. Hope this helps but shout up if not!
User | Count |
---|---|
19 | |
15 | |
13 | |
9 | |
8 |