Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Using one excel sheet data to overwrite cells in other sheet

mbajic
6 - Meteoroid

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

6 REPLIES 6
JarekSkudrzyk
11 - Bolide

@mbajic please take a look at my workflow for sample solution

mbajic
6 - Meteoroid

Thank you for response, I will try it out and give you a feedback.

mbajic
6 - Meteoroid

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.

mbajic
6 - Meteoroid

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!

JarekSkudrzyk
11 - Bolide

@mbajic 

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)

JarekSkudrzyk_0-1649838611237.png

 

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:

JarekSkudrzyk_1-1649838748987.png

 

- 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)

JarekSkudrzyk_2-1649838969180.png

 

It should work fine. Please let me know if it does not.

JarekSkudrzyk
11 - Bolide

@mbajic sorry - did not notice your message that you succeeded:)
anyways - you are welcome, I am glad this worked for you!

Labels
Top Solution Authors