Add sequence column to table

1

I have a table that has no column with unique identifiers (from excel). I want create a column that can act as a PRIMARY KEY in PG SQL.

I see there is a transform for creating a sequence (in a new table). But

  1. I want the numbers to only go from 1…last row number
  2. Want to append (LOOKUP?) this to the exiting table as a new column (simple Lookup requires that there be a join key, I think MERGE does also). In this case, I don’t want any form of MERGE. Just to append the column to the exiting table.

Perhaps there is a different way to achieve this?

2

Try the enumerate action for generating consecutive numbers

3

Thank you very much for the quick reply