Hi, I am creating a project where I am loading transformed data into a database. I would like to use the database command in EasyMorph to create the table and then add the data. I would also like to have an ID column for each of my rows. I have considered using the enumerate rows column but sinc…

Hi Shaheed, You can use the custom field definition mode as described here: Excel export to PostgreSQL with Primary key - #4 by andrew.rybka with key word AUTO_INCREMENT.

Thanks for your help. One follow up question. The example in the aforementioned post appears to show the keys already generated in EM. Would it work if I created a blank column and let SQL Server fill in the keys?

[image] Shaheed_Fazal: Would it work if I created a blank column and let SQL Server fill in the keys? I don't see why it shouldn't.

EasyMorph Community - Data preparation professionals and enthusiasts

Best practice on creating an ID column via database command

To learn more about EasyMorph visit easymorph.com.