Insights - Relationship duplicate information from dataset

Anonymous User

Hi everyone.

During my experience with #Insigths and #Survey123, I have noticed that when I create relationship between one dataset (main) and other dataset (from the groups of repeat of the Form), the new dataset duplicate the information, in this way if I want to filter common infomation between the two dataset, the result is incorrect in the Pivot Table. There is a one way to work with this information for filtering two or more dataset without the need of create relationship? The only key between the two dataset is the "Creationdate".

Thanks

JamesTedrick

Hi,

This is probably better addressed in the Insights for ArcGIS‌ group.  I would suggest that rather than CreationDate, you try adding a field to the parent of the relationship and copy the globalid value into it - that would be the better key for the relationship.