Text from SharePoint truncating when sent to database

[sarah-locaputo]

Hi there. I am having issues with text truncating. The data comes from a SharePoint multiple lines of text field. It can be viewed fully in Alteryx when pulled in from SharePoint. However, when I try to send it to a database, the text gets truncated. How do I fix this?

[JimmyV]

Hi Sarah,

Based on what I can see here, I would suggest checking the data type and size of the field that you're sending to the output (database table). Then I would also confirm that the field data type and size matches or allows the same size of data to be inserted into your database table destination.

In Alteryx, I usually like to add in a Select tool as the last tool before any Output Data tool to any database so I can confirm the correct/matching data type and size going to the source database tables.