We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

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

SQQL Query (Salesforce Input)

TommyLau
6 - Meteoroid
‎09-15-2021 08:06 PM

TommyLau_0-1631761484179.png

Hi, any solutions for this issue? Thanks

Labels:
Reply
0 Likes
3 REPLIES 3
BrandonB
Alteryx
Alteryx
‎09-15-2021 08:36 PM

It looks like SalesForce doesn't like the plus operators in your WHERE clause. Are you trying to look for names that have a carriage return in them? 

Reply
0 Likes
TommyLau
6 - Meteoroid
‎09-15-2021 08:45 PM

Thanks for the reply, but I couldn't find any other operators that can replace "+"

Reply
0 Likes
BrandonB
Alteryx
Alteryx
‎09-16-2021 07:07 AM

Aren't New Line and Carriage Return represented by \n and \r respectively? https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_sel... 

 

It has been a bit since I have written SOQL, but wouldn't it be something like: WHERE name LIKE '%\r%'

Reply
0 Likes
Copilot AMA
Live Office Hours
Labels
Top Solution Authors
View All