When we create the variables below we CONCAT ',' to every Id ... But for the IN statement to work the last ID must NOT have a ','
i.e WHERE Id IN ('1','2','3')
ListLead:
LOAD Concat(DISTINCT Chr(39) & LeadId & Chr(39), ',') as ListLead,
;
SELECT *
FROM CampaignMember
WHERE CampaignId = '7011O0000021IGvQAM';
LET vListLead = Peek('ListLead.ListLead');
TRACE $(vListLead);
ListContact:
LOAD Concat(DISTINCT Chr(39) & ContactId & Chr(39), ',') as ListContact,
;
SELECT *
FROM CampaignMember
WHERE CampaignId = '7011O0000021IGvQAM';
LET vListContact = Peek('ListContact.ListContact');
TRACE $(vListContact);
Below is where I want to use the variable to only select IDs identified in a specific campaign:
Who:
UNQUALIFY *;
LOAD Id as WhoId,
Id as WhoId2,
Title as WhoTitle,
Email as WhoEmail,
LeanData__Reporting_Matched_Account__c as AccountId,
Company;
SELECT *
FROM Lead
WHERE Id IN
('$(vListLead)');
Concatenate(Who)Add
LOAD Id as WhoId,
Id as WhoId2,
AccountId,
Title as WhoTitle,
Email as WhoEmail;
SELECT *
FROM Contact
WHERE Id IN
('$(vListContact)');
EXIT SCRIPT;
