Alteryx Output Tool Error

[arsh011]

I am trying to append my excel file using the output tool but this error comes, how can I fix this? Please help!!!

[NikyN]

Hello @arsh011,

can you share WF with us? I believe that the field name is not matching to the one that is already existing in the excel.

Best Luck!

NN

[AkimasaKajitani]

Hi @arsh011 ,

As @NikyN said, If you use the option "Append To Existing Sheet" at Output Data tool, you need to have the same fields name  as output excel field name.

Please check the field name.

[amruthas2 · Accepted solution]

Hi @arsh011 

Append needs exact same number of columns from both the tables, please see the below options to mitigate the error.

1. You need to rename the column Quantity with the other exisitng table. Say it is called as "Qty" in Table 1, and "Quantity" in Table 2, you will have to rename either 1
2. If Table 1 has Quantity and Table 2 doesnt have it at all, before Appending, Use 'Formula' function to create a new column called 'Quantity' with null() , and then append the tables.

Please let me know if this helps 

[arsh011]

Thanks @amruthas2  ... it really works!!

[amruthas2]

@arsh011  happy to help :)