I am trying to append my excel file using the output tool but this error comes, how can I fix this? Please help!!!
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 12. 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
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
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.
Thanks @amruthas2 ... it really works!!
@arsh011 happy to help
