I think you want Line Sequence Number

Question

< pmendola> I think you want Line Sequence Number

pmendola · Answer

using that field still skips the lines I was able to get it displayed mostly correctly using case and decode but still not perfect

michoel · Answer

Just came across this might help you

michoel · Answer

michoel · Answer

Formula Numeric | RANK OVER PARTITION BY number ORDER BY linesequencenumber