Forum Discussion
How to Convert New Sales Territory/Rep Data Table with Single Date "Event" Rows
Thank you, ZhangKun, SundarRaj and ronrsnfld, for your responses.
Hi zwyatt,
We would like to check if the solution provided by ZhangKun, SundarRaj, ronrsnfld has resolved your issue. If you have found an alternative approach, we encourage you to share it with the community to assist others facing similar challenges.
If you found the response helpful, please mark it as the accepted solution. This recognition benefits other members seeking solutions to similar queries.Thank you.
Thank you, ZhangKun, SundarRaj and ronrsnfld, for your responses.
Hi zwyatt,
We would like to check if the solution provided by ZhangKun, SundarRaj, ronrsnfld has resolved your issue. If you have found an alternative approach, we encourage you to share it with the community to assist others facing similar challenges.
If you found the response helpful, please mark it as the accepted solution. This recognition benefits other members seeking solutions to similar queries.
Thank you.
Hey guys. Apologies for the delay.
Yes! The original solution posted by ZhangKun worked! All I had to adjust was the End Date variable from a static date, to a dynamic pull for Prior Day's date.
Also, a few minutes of trial and error to swap in my actual data source and add'l columns.
Other than those, please consider it solved.
I haven't had a chance to review the other submissions, besides a cursory "skim" over, but will dig into them today, to see if there's improvement in elegance or efficiency.
Thanks again!