Skip to main content
  • EN

I have an Oracle table with rows organized in groups, each group with an unique attribute name, WELL_NAME, and sorted by an attribute, DEPTH. I want to add an attribute called SURVEY_NO that auto generates a sequential number for each row within each group, starting with 1, then 2, .. and end with the last row in that sorted group. So it will look like:

WELL_NAME DEPTH SURVEY_NO

name1 10 1

name1 20 2

name1 30 3

name2 10 1

name2 20 2

name3 30 3

You can use a Counter with the counter name set to WELL_NAME:

You can use a Counter with the counter name set to WELL_NAME:

I thought it's the best answer, but it cannot be explained why the SURVEY_NO for the row of "name3" becomes 3...

 

 

I thought it's the best answer, but it cannot be explained why the SURVEY_NO for the row of "name3" becomes 3...

 

 

I just assumed it was a typo 😉

You can use a Counter with the counter name set to WELL_NAME:

David, yes it works perfect. Again glory to FME.

 

 

Sorry for the typo, Takashi.

 

 

Allen

 

 

Reply


Community Stats

30,190
Posts
114,591
Replies
37,854
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.