Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
this is simply the solution
left Join (Table_final)
Load
Distinct
min (Sales) as Sales,
1 as flagmin
resident Table_final;
Something like this?
Sum({<flagmin={1}>} Sales)
Hello with this code for the flag will display only 1
this is simply the solution
left Join (Table_final)
Load
Distinct
min (Sales) as Sales,
1 as flagmin
resident Table_final;