I am trying to identify relationships between 3 relations. I have a large dataset whith 3 dimensions.
- Debitor ID
- CVR ID
- KF ID
These are all listed in one long list where each row (Debitor, CVR and KF) is unique. However the Debitor ID can appear more than one time with two different CVR ID, but maybe with the same KF ID. The same thing can happen with the other two dimensions. That means that there is many to many relationships between the two.
Is it possible to make some kind of code and input the dataset to it, and make it loop through all rows and find the relationsships between all rows and assigning it a unique Client-Group?
I attempted to do a sketch of how the data is, and how the relationships are - and what I want to get in the end. Screenshot with explanation of data relations and how it should be grouped in the end.
So how do I make a unique ID that groups related rows?