Range - Write output

[Sarath27]

Hi All,

Please assist me on this scenario where I have been struggling to achieve this for long.

I have four diff outputs from different tool, I need to write everything in one sheet by applying Range using formula tool. But I cant figure out the solutions.

Please kindly refer my sample workflow attached and also take a look at the screenshot for the required output format.

Four outputs should be written in a same sheet (just like we create excel pivot by selecting ranges)

[ed_hayter]

was curious if the output could be achieved with reporting tools. Outcome matches the expected output except because ive used report tools I've had to fill the cells - this can be edited in excel with a no fill setting (not ideal but a by-product of this alternative approach.

[Rags1982]

One thing you could do is to set up named ranges in your Excel document. (Use the search bar, top middle of Excel to search for Named Range). This allows you to set specific cells as a named range. Then, in your workflow, rather than setting a sheet to write to on your output, you enter then named range. 

Alteryx will then write to that specific range on output, meaning that you can write to the same sheet using the 'Overwrite Sheet or Range' option. 

[Sarath27]

Yes I did the same. But reporting tool took longer time to run.  That's why I have chosen the other option. Anyway let me try your workflow and see if it feasible to my case.

Thanks much 

[Sarath27]

I have a file specification file where the output has to be written in the mentioned file path. That's why I am looking for this alternate