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.