topic Re: Count duplicate - Load Script in QlikView

Count duplicate - Load Script

tamilarasu — Tue, 30 Jun 2015 03:32:39 GMT

Hello,

I have two excel files, one is source file and another is mapping file. In source file, I have unique products and want to map this with mapping file to find out the frequency. Say for example, I have a product name called "A" in source file and mapping file have 6 entries. I just want to count this while loading (A new column would be fine). Any Idea ?

Thank you.

Re: Count duplicate - Load Script

Siva_Sankar — Tue, 30 Jun 2015 03:45:26 GMT

!PFA

Re: Count duplicate - Load Script

tamilarasu — Tue, 30 Jun 2015 04:20:12 GMT

I guess you have misunderstood the question. Please see the below screenshot.

P.S: I need to this in load script

Re: Count duplicate - Load Script

Tue, 30 Jun 2015 04:36:03 GMT

xl1:
Load Product, Count(Product) As Cnt Group By Product ;
LOAD * Inline
[Product, Value
A,12
A,5
A,56
B,2
B,3
C,4
D,6
E,5 ];

xl1:Load Product, Count(Product) As Cnt Group By Product ;LOAD * Inline[Product, ValueA,12A,5A,56B,2B,3C,4D,6E,5 ];

Re: Count duplicate - Load Script

Anonymous — Tue, 30 Jun 2015 04:46:15 GMT

Hi,

Select Product, Value as dimensions of straight table, and write expression Count(Product)

Hope it will helpful!!

Re: Count duplicate - Load Script

tamilarasu — Tue, 30 Jun 2015 04:53:56 GMT

Faisal's solution working as expected. Thank you all.

Re: Count duplicate - Load Script

Siva_Sankar — Tue, 30 Jun 2015 05:06:24 GMT

oh..sorry. I misunderstood your requirement.

Re: Count duplicate - Load Script

tamilarasu — Tue, 30 Jun 2015 05:09:39 GMT

Shankar: Thanks for the reply. Have a nice day.

Re: Count duplicate - Load Script

ankitbisht01 — Tue, 30 Jun 2015 08:33:55 GMT

PFA

Output as per this requirnment.