Forum Discussion
Date Relationships
I have 2 datasets each hold dates within them to link customer to products, I would like to know how to create a Relationships between them... I know i need to create a new dataset as the lookup dataset, however I need help in setting this up and maintaining it.
please see the image below:
I have the two dataset A and dataset B... I would like to know:
- how to create the lookup relationship dataset from A and or B
- how to maintain the dataset when refreshing dataset A and B
- how to update A and B with the PK in the relationship dataset
- is this the correct way to achieve the relationship?
many thanks, any help would be welcomed.
Paul
2 Replies
Hi Paul1762,
Based on my test, you could create a many to many relationship(you have to update the latest version(2.60.5169.4101 64-bit (July 2018)), and you could refer to below steps:
1.Sample data:
2.Create relationships.
3.Now you could see the result.
For the update and refresh, you just need to click the "Refresh" button in the home ribbon.
Regards,
Daniel He
Hi Paul1762,
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?
Regards,
Daniel He
