'Group by' function in a Data Set on multiple fields

Hi,

I would like to know if it's possible to make a 'Group by' like in SQL99 on a data set on multiple fields in order to get some values (max / min / count) of each group.

Regards - Matthieu

Find more posts tagged with

Comments

bhanley

You can enter your SQL directly in the Data Set editor and include your GROUP BY clause there.

Are you trying this and experiencing a specific issue?

Matthieu

Actually the set I would like to use is not a SQL query result.
I got it after joining multiple data set so I can't use the SQL query.

Since I can't use table aliases in my SQL queries, I don't see another way to do.