Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Don't load data without associated records

I have three tables I'm loading. Activities, Contacts and Accounts (related as per below)

table.bmp

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 *;

10 Replies
Not applicable
Author

Thanks Nicole, the UNQUALIFY statement worked!