topic Re: Aggr on load script in QlikView

Aggr on load script

Sat, 20 Jul 2013 03:28:12 GMT

Hello,

I need to group some fields in a table from the load script. I am not sure of the syntaxis so I need some help here. I am connecting directly to the database. Here is an example of what I need:

I have Table1 with fields A,B,C,D and I need to count field D and group by A. What are the steps I need to follow? Please include also the SQL SELECT * FROM db.table line.

Thank you,

Juan.

Re: Aggr on load script

Sokkorn — Sat, 20 Jul 2013 03:58:57 GMT

Hi Juan,

Not sure you try this yet

SQL SELECT A, COUNT(D) FROM db.table;

Regards,

Sokkorn

Re: Aggr on load script

Sat, 20 Jul 2013 04:17:58 GMT

Hello Sokkorn,

I tried it but it isn't retrieving the data as I need it. I need to group repeated fields to reduce lines and memory.

Juan.

Re: Aggr on load script

Sokkorn — Sat, 20 Jul 2013 04:32:05 GMT

Hi Juan,

SQL SELECT A,B,C, COUNT(D) AS D FROM db.table Group By A,B,C;

Regards,

Sokkorn