Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have three tables I'm loading. Activities, Contacts and Accounts (related as per below)
How do I change my load script for Accounts, to only include records which have associated activities?
QUALIFY *;
UNQUALIFY Activity.AccountId;
UNQUALIFY AccountIdforTag;
Accounts:
LOAD Id AS Activity.AccountId,
Id AS AccountIdforTag,
IsDeleted,
Name,
Country__c;
SQL SELECT *
FROM Account;
UNQUALIFY *;
Similarly how would I amend mt load script for Contacts, to only include contacts with related activities?
QUALIFY *;
UNQUALIFY Activity.ConatctRecordTypeId;
UNQUALIFY Activity.AccountId;
UNQUALIFY Activity.ContactId;
UNQUALIFY Activity.Department_Role__c;
UNQUALIFY Activity.Business__c;
Contacts:
LOAD Id as Activity.ContactId,
AccountId AS Activity.AccountId,
Name,
RecordTypeId AS Activity.ConatctRecordTypeId,
Department_Role__c AS Activity.Department_Role__c,
Inactive_Contact__c,
Business__c AS Activity.Business__c;
SQL SELECT *
FROM Contact;
UNQUALIFY *;
Thanks Nicole, the UNQUALIFY statement worked!