How do I read the value of master group record?

[kkhozema]

I am trying to do as below:

TempItemMaster:

LOAD * INLINE [

OrgCode, ItemNumber, ProcessiongTime

1000, PartNumber1, 15

581, PartNumber1, 10

600, PartNumber1, 40

581, PartNumber2, 16

600, PartNumber2, 16

2000, PartNumber2, 12

];

ItemMaster:

NoConcatenate

LOAD OrgCode,

ItemNumber,
ProcessiongTime,

AutoNumber(Recno(), ItemNumber) as Rank,
If(ItemNumber = Previous(ItemNumber), RangeSum(Peek('RankPeek'), 1), 1) as RankPeek

Resident TempItemMaster

ORDER BY ItemNumber DESC, OrgCode asc;

DROP Table TempItemMaster;

What i need is as follows

[Kushal_Chawda]

@kkhozema  try below in your resident load 

if(ItemNumber<>previous(ItemNumber), ProcessingTime & ' Value Derived from '&OrgCode& ' | ' &ItemNumber, peek(PreProcessingTime)) as PreProcessingTime

[kkhozema]

It works on the sample data set. But not on the actual data.

I need is to work on a bigger dataset.

I will try to explain better