Alteryx Designer Desktop Discussions

KamenRider

Hi Guys,

I have this excel file that I would like to arrange its positions that would reflect using the Output Data Tool. Current results look like this:

And I wanted it to be converted or look like this:

I hope anyone would help me with this kind of results

Thanks,

Kamen.

rzdodson

@KamenRider here is one approach.

KamenRider

Hi @rzdodson

Thanks for the response. However, is it possible to use the output data tool? We will not be using table and render tool. The reason is that the output which is the sheet tab is being appended in another excel. I have use the render tool and the result remove the other sheet tabs which is being overwritten with this result.

Please advise.

thanks,

Kamen

rzdodson

@KamenRider add a Union tool connecting the top Select tool with the Multi-Field Formula tool. Then, attach an Output tool to the Union tool. Then, change the Output Options to Append To Existing Sheet.

KamenRider

Hi @rzdodson

Thanks. Can I ask for a sample workflow. I am wondering what's in the multi-formula tool.

Thanks,

Kamen

rzdodson

@KamenRider open the workflow that was a part of my first reply. It is the second tool to the right of the Text Input tool in the second row of the workflow.