Output for Join Function

[micou]

Hello,

I'm just wondering if it is possible to output 3 tabs (un-joined left, un-joined right and joined records) in one excel sheet ? Thank you!

[fmvizcaino]

Hi @micou ,

Attached is an example showing how to accomplish this.

Since it is possible to have a problem when trying to generate 3 sheets at the same time, I'm using a dynamic creation of sheets based on a column value.

LEt me know if this works for you.

Best,

Fernando Vizcaino

[estherb47 · Accepted solution]

Hi @micou 

You can also try an output tool after setting up the formula tool to name the sheets. I chose, at the bottom of the Output Data tool configuration, to append the field to the sheet name. You can also choose to replace the sheet name with the field. Just be sure to choose to "Overwrite sheet" if you intend to run the workflow more than once.

If Alteryx errors on the writing, drop a block until done tool before the topmost output data tool, and it should work. I found with this small data set, I didn't need one.

Let me know if this works.

Cheers! Esther

[micou]

thank you!!!

[micou]

Thank you!! it works!!