Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Added on September 28, 2022 7:53AM
Likes: 0
Replies: 1
I have input dataset in the form of excel file with following format:
WORK_ID | WORK_NAME | RF_NAME |
Target Dataset if postgresql table with following def:
CREATE TABLE dl_insight_zone.DIM_INITIATIVE(
INIT_UNIQUE_ID SERIAL PRIMARY KEY,
WORK_ID varchar(80),
WORK_NAME text,
RF_NAME text
);
I want to create auto-generated primary key with each record insertion. However, I am not able to do that. Please suggest options with sync/prepare recipe or any other way to do this.
Hi @chiraggiri
,
You can accomplish this by using a Window recipe to create an auto-incrementing column, and then setting the column as the primary key:
Rebuild the dataset. The auto-incrementing column should now be the primary key.
Here's a picture of how it looks in the flow. prod_rate is the Excel dataset, and prod_rate_window is the Postgres dataset:
Feel free to let me know if you have any questions.
Thanks,
Zach