This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Sounds like an algorithm would be needed to do this efficiently, ideally already coded as an R package that you could run inside an Alteryx workflow. I did a few google searches, but couldn't find anything; sorry. Maybe with more time and diligence you could find something, versus trying to write something from scratch.
Do you have some sample data that we can work with together? If you're able to mock this up like @JoeM and @MattD do with the weekly challenges, then we can rope in the community to see if we can crack this together with you?
We do have challenges that sound similar, but if you have any example data then we can get a specific solution for your problem