Pick data from both tables and create a new table

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

Database Connection

Accepted answers

atcodedog05

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 😀👍

stock allocate.yxmd

Qiu

@lzhang775
kindly give your comments

1125-lzhang775.yxmd

All comments

atcodedog05

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 😀👍

stock allocate.yxmd

Qiu

@lzhang775
kindly give your comments

1125-lzhang775.yxmd

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

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

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335