Output to Excel with Join L & J in different output tabs

I am running a reconciliation process and need to out put the data which has matched in the Join tool (J) and the data which has not matched in the Join tool (L). Is there a way to output this into the same Excel workbook but in different sheet?

To visualise this, attached is the join tool to two outputs. I would want the output to be the same Excel file but with the data across two tabs.

Thank you in advance.

Join output to different sheets.PNG

Output

Join

Accepted answers

atcodedog05

Hi @tom05

You should be able to get it with what you are doing by mentioning different sheets in the output.

What the error you are getting. We can trouble shoot it for you.

atcodedog05

Hi @tom05

I think a error like this. Which is file lock issue happens due to simultaneous file writing.

Can be fixed by using Block Until Done tool.

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

If the issue you are facing is something please do let us know.

unmatch.yxmd

All comments

AngelosPachis

Jonathan-Sherman

Hi @tom05,

You would need to create a filepath (with sheet name) in a formula tool after the L and J anchors and use this as the file name to write out to.

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

20201006 - OutputFiles.yxzp

atcodedog05

Hi @tom05

You should be able to get it with what you are doing by mentioning different sheets in the output.

What the error you are getting. We can trouble shoot it for you.

atcodedog05

Hi @tom05

I think a error like this. Which is file lock issue happens due to simultaneous file writing.

Can be fixed by using Block Until Done tool.

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

If the issue you are facing is something please do let us know.

unmatch.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703