Range - Write output

Question

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)

Range formula.yxmd

Range formula.PNG

Sarath27 · Answer

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

Sarath27 · Answer

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

Rags1982 · Answer

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.