Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
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