Replicating and excel sheet in alteryx
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
hi @sg22
are you able to attach your workflow with how you have progressed so far? It might be easier for me to start from that point.
Cheers,
TheOC
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@sg22
We can use the option of "Preserve Formatting" while outputting Excel file.
But it will difficult to be dynamic in your case.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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:
