hello, my dataset consists of a left join of two datasets, Cancellations and Active Sessions. i’ve been having these issues:
- refreshing my dataset causes a duplicate aliases error about a field in Cancellations and Last Active Sessions, which i’ll call ID. however, creating a new dataset with the same left join of Cancellations and Active Sessions does not trigger any error. additionally, the refresh succeeded a month ago, and ID was included in both Cancellations and Active Sessions a month ago. the join was also not changed since a month ago
- trying to view my dataset triggers an error message about a calculated field in Cancellations, which ill call Count. Count is trying to reference ID, and the error says ID either does not exist or is excluded in Cancellations, neither of which is true. additionally, viewing Cancellations does not trip this error
- when i remove Active Sessions from the dataset, it triggers an error message in preview, the message being that something is wrong. it does not let me save when Active Sessions is deleted.
- i cannot remove Cancellations from the dataset even when i remove its join to Active Sessions. removing Active Sessions and then removing Cancellations crashes the dataset entirely
i feel that since left joining Cancellations and Active Sessions in a new dataset doesn’t trigger any error, there might be some kind of system issue at play here, but i’m not sure about any kind of workaround aside from recreating the dataset from scratch. does anyone have any suggestions about what might cause this error or what i can do to mitigate it?