topic Re: LOAD Distinct Error in QlikView

LOAD Distinct Error

mphekin12 — Thu, 30 Jan 2014 17:45:28 GMT

I'm hoping someone can help me out. I'm using LOAD Disctinct to get a table with just the distinct companies we have. There should only be two rows in this table, but for some reason there are over a million records. It's like the 'Distinct' keyword isn't working at all. My script is below:

Company:

     LOAD
           *,
          1 as C.Count
      ;
      LOAD Distinct
           Company as C.Company
      FROM $(vData)\Main.qvd (qvd);

Can anyone tell me why just the distinct companies aren't making it into the Company table?

Any help would be greatly appreciated!

Re: LOAD Distinct Error

Anonymous — Thu, 30 Jan 2014 17:51:26 GMT

Are there any other tables that have the field C.Company ?

What happens if you isolate the load distinct ?

NoConcatenate

DistinctCompany :

LOAD Distinct

Company as DistinctCompanyField

FROM $(vData)\Main.qvd (qvd);

Best Regards, Bill

Re: LOAD Distinct Error

santharubban — Thu, 30 Jan 2014 17:56:28 GMT

Mphekin,

try this

Company:

LOAD Distinct
           *,
          1 as C.Count
      ;
      LOAD
           Company as C.Company
      FROM $(vData)\Main.qvd (qvd);

Re: LOAD Distinct Error

hic — Thu, 30 Jan 2014 18:00:39 GMT

You're right. The distinct keyword is ignored, unless it is found in the topmost Load.

HIC

Re: LOAD Distinct Error

mphekin12 — Thu, 30 Jan 2014 19:46:22 GMT

Thank you all for your help!