Data360 Analyze

Hi Support,

I'm hoping that someone can develop a D360 version of Excel - Solver

I have provided an example of the data I am working with and how to group multiple lots.  I need it to cycle through multiple lots of transactions.  I would also like to be able to increase or reduce the amount of permutations it will cycle through.



I need it to look at the 1st lot of trans (green items)

After running solver it found the items in Orange which were the correct permutation

I then need it to move onto the next lot of transactions in Yellow and perform the below solver

Results in pink

I'm really hoping that someone can help me build this..

Looking forward to your reply

------------------------------
andrew darnell
Knowledge Community Shared Account
------------------------------

A Transform node can do what can be done with pure Python 2.7 code. 

The Python node can use the rest of the Python 2.7 libraries.  The reason I'm saying this is I'm not exactly sure what you are asking, but went to ChatGPT to get an idea what you would need.  It suggested using scipy which it says is not a "pure Python" library.  It seems that it is available in Python 2.7 though, so you could use the Python node with it.