Load rows with lower value per dimensions

nikolis_gr — Mon, 07 Jan 2019 13:46:58 GMT

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?

Re: Load rows with lower value per dimensions

sunny_talwar — Mon, 07 Jan 2019 14:19:27 GMT

May be this

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