Select the first process from process step on a job.
This is a difficult one to explain, here goes. Ordernumber (first column) has different steps ie more than one task, i want to only have during the load or in set analysis the first step which is identified by the prosequence (column 5 below).
ie ordernumber 168599 has two step 1250 and 1150 these number can can but the prosequence column is indexing based on process, i want to only show for 168599 below, and the first or lowest number in prosequence for each ordernumber . so each ordernumber would only show one record and that would be the lowest prosequence number for that ordernumber.