Hi,
I asked a similar question but now the situation changed. I believe the original solution will not fit in this situation so I create a new post. Can anyone give me some suggestions on this table join issue?
Thank you so much in advance!
LEE
Solved! Go to Solution.
Hi @lzhang775
Here is a workflow for the task.
Output:
Workflow:
Hope this helps 🙂 Feel to ask if you have any questions
If this post helps you please mark it as solution. And give a like if you dont mind 😀👍
@lzhang775
kindly give your comments
Hi Atcodedog05,
Thank you for your suggestion, this is pretty like my last answer. The length number in the sample is an easy one, but in fact, our system allowed 3 decimal, and this method may not work perfectly.
I am looking for a logic workflow if the left table can pick the right table data in order. do you have any suggestions?
Thanks
LEE
Hi @lzhang775
I do agree this is not efficient but this is one of the common way how stock allocation is solved.
I really dont know how else can it be solved and whether another method exists.
For any method chosen we need to split single quantity to each row and do a stock allocation.
Understand, I will keep working on this one. thank you for your suggestion!!
LEE
Thank you, Qiu!
This method may closer to what I wanted. I may need to manipulate some steps, but your idea helped me! thank you!
LEE