Forum Discussion
Create row(s) according to values into different columns
I'm trying to "denormalize" data from Exchange calendar. Dataset is a list of appointments from outlook calendar mixing recursive and single appointment. Recursive appointments are single entries wi...
Hi crixo
When filtering the Recurrence, it also has many records.
Do you mean you want to expand all the content of it based on the happened times? If you expanded it, it will return muitiple rows.
Best Regards!
Yolo Zhu
Hi Anonymous,
Yes, I need to duplicate each row that is an appointment with the Recurrence data.
For ex. if I dectected, according to Recurrence.HasEnd not null, that an appointment/row has Recurrence.NumberOfOccurrences = 20, I will duplicate that row Recurrence.NumberOfOccurrences-1 where 1 is the row itself.
I need to duplicate the row to count each physical occurence after groupping by its category.
I hope that helps to clarify the scenario. Thanks a lot for your support