Using one excel sheet data to overwrite cells in other sheet
- 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
Hello,
I am new to Alteryx and have a question. Does anybody have an idea on how to use specific fields in one excel sheet and then just transfer those fields to another sheet. The 2 sheets are not of same format (e.g. data in cell C4 in first one needs to become the same data in cell D5 in the second sheet). Important thing is that there are no changes in values, it is basically copy/paste. I do not know if there is an option to specify 5-6 fields in the input and then in the output.
Thanks to anyone that helps
Matej
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@mbajic please take a look at my workflow for sample solution
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you for response, I will try it out and give you a feedback.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I am not achieving anything with your workflow, it is possible I am not using it correctly. I will put more details below.
In Table 1 I have a name which I need to put into Table 2. (e.g. cell A2)
Table 1 |
John Smith |
And from Table 2 i want xyz to be replaced by John Smith (e.g. cell B2)
Table 2 | ----------------------- |
--------------- | xyz |
Both of these tables are filled with other data.
End result is:
Table 2 | ------------------ |
-------------- | John Smith |
Thank you for your time and patience, I hope you can help me.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have succeeded, I did not define the previous cells properly, in the first input I need to define the cell John Smith, but in the second I put the whole Table 2. Then in the output I define the cell that needs to be replaced.
Thank you very much!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
let me explain how to set up the workflow correctly:
Input - you need to select the proper range from which to import and tick "first row contains data" - this way the first row of imported data will not become column header (this step is not mandatory - it depends on what you want to achieve; in my example I ticked it)
Block until done - this is needed if you want to write output to the same file you have used as input (otherwise there is an error that the file cannot be opened for writing)
Output - here you have to set up a few things:
- you have to specify a range within the sheet:
- then set Output Options to "Overwrite sheet or range" and tick "Preserve formatting..."
you may also want to tick "skip field names" - depending on what you have set in Input tool (if first row of data became a column header i.e. field name - in my case I ticked "skip field names" because of how I set up the input tool)
It should work fine. Please let me know if it does not.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@mbajic sorry - did not notice your message that you succeeded:)
anyways - you are welcome, I am glad this worked for you!