• Andre Largie 1
  • NEWBIE
  • 0 Points
  • Member since 2017

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 0
    Replies
Hi,

I'm having a hard time creating a SAQL statement that will allow me to match records that contain one of many string values.  I'm trying to filter on records that contain "scratch" or "cut" in the notes.  Any suggestions?  Thanks in advance.

The following statement won't work for me:

q = load "All_Baby_Salesforce";
q = filter q by 'SAP_Notes_Internal' matches ["scratch" || "cut" ];
q = group q by all;
q = foreach q generate unique('CP_ID') as 'unique_CP_ID';
q = limit q 2000;