Replicating and excel sheet in alteryx

Question

Hi all,

I want to automate an excel sheet which I have designed. There are multiple elements and I am having issues converting this sheet into Alteryx workflow.

Attached is the file for reference. The Input tab consists for formulas and Output tab depicts the desired output.

I'm using different Input anchors. I want to overwrite the amounts as Input tab is a template I'm supposed to use. All the combinations I have tried messes up the order and I can't overwrite the cells as they correspond with the details on column B.

Any guidance is much appreciated!

Sample.xlsx

sg22 · Answer

@Qiu

I'm already using the preferences you mentioned for the output tool. But since, the data itself is not in correct order the output is off too. Please refer to the below image:

sg22 · Answer

@TheOC

I managed to make some changes in workflow for the first Part, and its almost same as the output, just that some rows are repeating as there are same numbers with different details on the Entity A tab. I've attached a screenshot of the workflow.

Qiu · Answer

@sg22 
We can use the option of "Preserve Formatting" while outputting Excel file.

But it will difficult to be dynamic in your case.

0225-sg22.yxmd