Numbering based on Date and Process

[girish2195]

Hi All,

Please find the below attachment for sample data.

I want to generate the number based on date and process.

If you look at the sample data you will get the idea.

Thanks in advance

Girish Kumar DV

[tresesco]

Try like:

Load

          Autonumber(RowNo(), Process) as CounterProcess

[Gysbert_Wassenaar]

Perhaps like this:

tmpUnsorted:

LOAD

     Date,

     Process

FROM

     ...source...

     ;

Result:

NOCONCATENATE LOAD

     Date,

     Process,

     If(Date=Previous(Date) And Process=Previous(Process), peek(Number)+1, 1) as Number

RESIDENT

     tmpUnSorted

ORDER BY

     Date,

     Process

     ;

DROP TABLE tmpUnsorted;

[tresesco · Accepted solution]

Now I notice that your Number also considers Date field. Try like:

AutoNumber(RowNo(),Process & Date) as Number