I need to generate the id col values. I don’t know how to make a rank or rownumber reset.

notice it goes back to one. When it gets to a new table. I 've been playing w dense rank but don’t see one where it goes back to 1.

am I making any sense? for some reason i'm having a really hard time explaining it