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

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

Output

Database Connection

Accepted answers

jrgo

@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

All comments

jrgo

@ZoeyL1GL

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.

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-Driver-Invalid-column-reference/ta-p/659179

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703