Aggr on load script

[#1]

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.

[Sokkorn]

Hi Juan,

Not sure you try this yet

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

Regards,

Sokkorn

[#3]

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.

[Sokkorn · Accepted solution]

Hi Juan,

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

Regards,

Sokkorn