community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Salesforce Input tool to SQL Service - field truncation

Highlighted
Meteoroid

I am using the Salesforce input tool to load SQL Server.  It works for most objects and fields.  But on the Opportunity object the Alteryx Salesforce Connection lists the field StageName as 40 characters long – but there are 248 records in Salesforce that are roughly 50 Characters long.   How can I fix this?    I changed the size of the field in SQL and that does not fix the issue, it is the 40 character on the Salesforce input side that seems to be causing the issue.

 

I believe Opportunity and StageNames are both standard Saleforce objects and fields.  It looks like we extended the field to 50 characters years ago, but Alteryx does not to adjust this field length for this new workflow.

 

Thanks 

Alteryx Certified Partner

Hi @BobC 

 

Looks like it's been awhile. Were you able to get this figured out? 

Labels