topic Re: display the line with min (Sales) in App Development

display the line with min (Sales)

zied_ahmed1 — Tue, 03 Dec 2019 10:03:34 GMT

Hello I have this code and I want to display in a table object only the row with the minimum sales via a flag

Table1:
Load * Inline [
Risque_id,Nom,Sales
1,Ahmed,100
2,Taxi,200
3,Hendo,300];

right join

Table2:
Load * Inline [
Risque_id,Country,agee,Language,date_birthday,agee_min

1,USA,77,English,03/04/2000,77
3,France ,99,French,05/07/2017,99

];

left Join (Table3)
Load
Distinct
Risque_id,
Min(Sales),

1 as flagmin

resident Table1
Group by Risque_id;

Thanks for help

Anil_Babu_Samineni — Tue, 03 Dec 2019 10:14:42 GMT

Something like this?

Sum({<flagmin={1}>} Sales)

zied_ahmed1 — Tue, 03 Dec 2019 10:16:15 GMT

Hello with this code for the flag will display only 1

zied_ahmed1 — Fri, 13 Dec 2019 12:58:26 GMT

this is simply the solution

left Join (Table_final)
Load
Distinct

min (Sales) as Sales,

1 as flagmin

resident Table_final;