Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Now I notice that your Number also considers Date field. Try like:
AutoNumber(RowNo(),Process & Date) as Number
Try like:
Load
Autonumber(RowNo(), Process) as CounterProcess
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;
Now I notice that your Number also considers Date field. Try like:
AutoNumber(RowNo(),Process & Date) as Number