write the script to derive output from input table

[sonysree88]

write the script to derive output from input table

[madhu_r · Accepted solution]

Hi,

Try this.

In dimension give Category and in measure give Max(Sales).

[its_anandrjs]

Hi,

Where you need this output

1. In Load script 

2. Front end

Regards,

Anand

[its_anandrjs]

On load script you can try this

DBSource:
LOAD * Inline
[
Product,Category,Sales
1,x,4000
2,x,5000
3,y,2000
4,y,4300

];

MaxSales:

LOAD
Category,
Max(Sales) as MaxSale
Resident DBSource
Group By Category;

Regards

Anand