Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Here's my question folks.
Thank you in advance
Something like this maybe:
TempTable:
LOAD
Field1,
Field2
From ;
MinMap:
Mapping Load:
Min(Field1) as Field1,
Field2
Resident TempTable Group By Field2;
NoConcatenate
Table:
LOAD
IF(Field1 = "NoData",ApplyMap('MinMap',Field1),Field1) as Field1
Field2
Resident TempTable;
Drop TempTable;
Something like this maybe:
TempTable:
LOAD
Field1,
Field2
From ;
MinMap:
Mapping Load:
Min(Field1) as Field1,
Field2
Resident TempTable Group By Field2;
NoConcatenate
Table:
LOAD
IF(Field1 = "NoData",ApplyMap('MinMap',Field1),Field1) as Field1
Field2
Resident TempTable;
Drop TempTable;
Checkout this script:
Table:
LOAD * Inline [
Field1, Field2
, Group1
0013, Group1
0012, Group1
, Group2
0015, Group2
0014, Group2
];
Join(Table)
LOAD Field2,
Min(Field1) as Min
Resident Table
Group By Field2;
FinalTable:
LOAD If(Len(Trim(Field1)) = 0, Min, Field1) as Field1,
Field2
Resident Table;
DROP Table Table;
Output in a chart where I am doing a count on Field1:
Thank you gentleman! Both answers work well