Row Consecutive

[Benjamin Gil]

Hello, I am trying to create a consecutive for each row in the ID column and I can't find a way, can anyone help me?

Thanks

[Uffe Kousgaard]

Hi,

Use "Table > update column" and then use function rowid() as value.

Kind regards
Uffe Kousgaard

On 04-03-2024 18:10, Benjamin Gil wrote:

Hello, I am trying to create a consecutive for each row in the ID column and I can't find a way, can anyone help me?

Thanks

--
--
You received this message because you are subscribed to the
Google Groups "MapInfo-L" group.To post a message to this group, send
email to mapi...@googlegroups.com
To unsubscribe from this group, go to:
http://groups.google.com/group/mapinfo-l/subscribe?hl=en
For more options, information and links to MapInfo resources (searching
archives, feature requests, to visit our Wiki, visit the Welcome page at
http://groups.google.com/group/mapinfo-l?hl=en

---
You received this message because you are subscribed to the Google Groups "MapInfo-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mapinfo-l+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/mapinfo-l/1f6492aa-ef3c-4829-a26d-9d452a1f7366n%40googlegroups.com.

[Peter Horsbøll Møller]

Uffe is right, but leave out () after rowid.

 

Here’s an example:

 

Peter

 

 

—

Peter Horsbøll Møller

Principal Sales Engineer - Distinguished Engineer

Precisely.com

 

From: mapi...@googlegroups.com <mapi...@googlegroups.com> On Behalf Of Uffe Kousgaard
Sent: 5. marts 2024 08:38
To: mapi...@googlegroups.com
Subject: Re: [MI-L] Row Consecutive

 

This message originated Externally. Use proper judgement and caution with attachments, links, or responses.

 

To view this discussion on the web visit https://groups.google.com/d/msgid/mapinfo-l/0d742085-f086-4e4d-a1a0-521dbf12e09f%40routeware.dk.

[Benjamin Gil]

Excellent, thanks a lot, it works perfec!!

Regards

[Benjamin Gil]

Hello, how can I create a column that indicates the year in all the rows, in another column the quarter and another some character value?

Ben.