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
- I want the numbers to only go from 1…last row number
- 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?