Load rows with lower value per dimensions

[nikolis_gr]

Hi community,

I have a table (table_A) which has 3 columns: ID,Resource, Value

It is populated with data like below:

ID     Resource     Value
1             A                  50
1             B                 100
25           F                 120
25           C                 120
..
23           G                   7
23           G                   7

I am trying to create a new table during load which will contain the lower Value and the Resource per ID with this but it is now working:

NoConcatenate
table_B:
LOAD ID,
FirstSortedValue(TOTAL <ID,Resource> Resource ,Value) as Rsrc
Resident table_A
group by TRUNK_ID;

Any help?

[sunny_talwar · Accepted solution]

May be this

NoConcatenate
table_B:
LOAD ID,
      FirstSortedValue(DISTINCT Resource, Value) as Rsrc
Resident table_A
Group By ID;