Join two tables without common field

[lzhang775]

Hi,

I couldn't find a way to join these two tables. Is anyone could help by giving me any suggestion!

Thank you in advance, couldn't move forward for two days.

LEE

[AkimasaKajitani · Accepted solution]

This is not simple join. It is needed some tools and logic to join the tables(It is a very interesting join method for me.).

I make sample Workflow.

Firstly I split the record each quantity by Generate Rows.

And I use the option "Join by Record Position" at Join tool.

After that I do total the Qty field by summarize tool.

[atcodedog05]

Hi @lzhang775 

Adding to the @AkimasaKajitani's solution. This scenario is not a normal join scenario this is more of resource allocation problem.

Hence you need to split the quantity into rows with single quantity per row and later doing a positional join.

First table is Orders and second table is Stock.

The final output is the table for which the resource was allocated.

Hope this gives you an understanding of the scenario 🙂 

[lzhang775]

Thank you so much!!! your suggestions are kinds of opening my mind.

[atcodedog05]

Happy to help 🙂 @lzhang775 

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any issues 🙂