topic Re: Only load customers with certain flag? in Connectivity & Data Prep

Only load customers with certain flag?

RJW — Tue, 02 Nov 2021 18:43:56 GMT

Hi,

I have a large list of customers IDs within a separate QVD file (>10,000 customers). Each customer has their own flag that categorizes them. In a new Qlik file, I only want to load customers from one of the categories. How might begin to write this script? The data looks like below:

Customer ID	Flag
0001	Northwest
0002	Southeast
0003	Northwest

So, for example, I only want to load Customer ID's from the Northwest region ONLY.

Re: Only load customers with certain flag?

rwunderlich — Tue, 02 Nov 2021 20:31:31 GMT

I'm unclear if the flag is in the main QVD file or a separate file?

If the same QVD then:

LOAD * From yourqvd.qvd (qvd)
Where Flag = 'Northwest';

If the flag is in a separate QVD the:

FlagTemp:
LOAD CustomeID From Flag.qvd (qvd)
Where Flag = 'Northwest';

Main:
Load * From Main.qvd (qvd)
Where exists (CustomerId);

Drop Table FlagTemp;

-Rob

Re: Only load customers with certain flag?

RJW — Wed, 03 Nov 2021 11:55:35 GMT

Thanks! The flag is in a separate QVD file maintained by other users at my company.

Would you be able to clarify the load statement in the Main table when you point to "Main. qvd"? Is that my file path or the separate QVD?

Re: Only load customers with certain flag?

rwunderlich — Wed, 03 Nov 2021 15:51:59 GMT

That is the file path to your qvd with all the data.

-Rob