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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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!