Pick data from both tables and create a new table

[lzhang775]

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

[atcodedog05 · Accepted 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 😀👍

[Qiu · Accepted solution]

@lzhang775 
kindly give your comments

[lzhang775]

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

[atcodedog05]

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.

[lzhang775]

Understand, I will keep working on this one. thank you for your suggestion!!

LEE

[lzhang775]

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