Too many fields IN DB tools

fiddycodes

We would like to upload to a PostGres database using IN-DB tools, we successfully performed the upload using Alteryx write to db output tool, but we want to leverage the power of IN-DB tools. When we use the write In-db tool, we get an error saying there are too many fields to write. Not sure what's going on. 

RobertOdera

Hi, @fiddycodes 

Consider checking the following:

1. does one of your input fields have a delimiter within the field value (likely forcing the creation of multiple columns in processing)? This can happen when the character being used as a delimiter also exists as a field value (e.g. comma in text)

2. is one of your input field's type/size/length too small (likely forcing truncation)? This can happen if you set the input field length too small

I hope you find this helpful - Cheers!