nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Max value by group by BIRT

yashesh

Hi,
 
I have a table in following format,
product name/product value
honda/10000
toyota/30000
honda/25000
GMC/40000
GMC/15000
toyota/18000
What I need to do is get a name of the product and corresponding max value for that product and get rid of duplicates.
So the output for above example would be,
honda/25000
toyota/30000
GMC/40000
 
Since this is coming from flat files, I do not have an option to a select * from distinct. What other methods can I use to get the intented output?
 
Thanks in advance.

Find more posts tagged with

Comments

micajblock

What version of BIRT? Ideally if you can send a flat file I can build a quick example/

yashesh

Hi mblock,
 
The BIRT version is 3.7. Please see a sample attached.
 
Regards

micajblock

Attached is an example (design and CSV). You simply need to select 'Auto Summarize On' when you drag in a table (see image below). The drag in Product Name, since it is a string it will automatically group by that field. Then drag in the Product Price, since it is a float it will automatically create an aggregation. Then all you need to do is change the aggregate from SUM to MAX.
 
I hope this helps.

yashesh

Thanks a ton Mica. You guys are the best!