Error: Output Data Unable to find field "field name" in output record.

[ZoeyL1GL]

I am getting an error from the Output Data tool

    Output Data (43)    Unable to find field "field_name " in output record.

when trying to create a new table from my workflow to a SQL server. My question is, this field is in my output table, and I am creating a new table on the database, it should not be trying to find the field in the database right?

Other workflows all work well when creating/appending new tables just stuck on this one. I have tried searching answers of the error but not many appears from the internet.

Any thoughts will be appretiated!

thanks,

Zoey

[jrgo · Accepted solution]

@ZoeyL1GL

Not 100%, but I’m thinking that the trailing space on your header name might be getting trimmed off by the SQL Server when it creates the table. As such, when it attempts to insert after the create, that ‘field_name ‘ no longer matches to ‘field_name’.

Put a select tool before your output and rename that field making sure theirs no leading/trailing spaces.

hope this helps!

Jimmy

[ZoeyL1GL]

thank you @jrgo - you spot it on! That was purely a silly mistake that I made - had a tailing space on one of my heaters in the table.

[yashanyway]

Hi I am facing a same issue and the field names are also correct with no leading/trailing white spaces. What could be the other reasons for this error?

[MGA]

Hi @yashanyway  were you able to solve it? Having same problem, many thanks. 

[basilm]

@yashanyway @MGA Were you able to finally figure out the root cause and the solution?

[ibraganza]

Hey this solution is outdated I found that this forum actually worked 

I USED SOLUTION B

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Knowledge-Base/Error-with-Simba-Hive-ODBC-...