Output Tool adds a blank row

I'm trying to append a column to an input excel file but the output tool adds a blank row as first row and the second row with the expected text. I selected append to existing sheet option from the output options menu and map by name from the append field name menu. The result is:

Header1 | Header2 | Field expected

<text> <text> blank

blank blank <text>

Output

Data Investigation

Accepted answers

All comments

ImadZidan

Hello @Istwineres ,

Can you please provide a sample file. It will be easier than guessing the input

Many thanks

Qiu

@Istwineres

Most likely your field mapping is not working as you expected.

Try to adjust the option as attached.

Istwineres

I tried that, same output a blank row than the expected output

Vijuzy

As you have selected append to existing sheet option from the output options, all the result will be appended after any used row in excel. Before executing the workflow open the excel sheet you are trying to append result to and press Ctrl+End from keyboard, now the selected cell should be end of your data row if any data already present else end of header row, if it ends in any other row (blank row) delete the entire row and save the excel file and try again. It should solve the blank row issue.

Let me know if this works.

Thanks,

Vijay

Istwineres

The issue is still present

ImadZidan

Hello @Istwineres ,

Here is a test workflow. Adding a col through a formula tool and append tool. They seem ok.

Lets take this as a starting point to understand the issue.

Please feel free to amend the workflow, replicate the issue and send back.

testColAppend.yxzp

Istwineres

Thanks for the help but that is not what I described as desired solution, moreover I'm aware of this and other solution I'm trying to figure out the specific case I mentioned in the original post.

Quick Links

This months top contributors

AkimasaKajitani 388

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335