Writing an Excel to a temporary table in Teradata SQL with a primary key

[alexisaharrison]

I have four excel files with 75,000 records each in them with the same data and unioned together. I want to create a temporary table from it in Teradata, but since the load it too larger, I need to create the table with a Primary Key using one of the fields that is in the excel data.

What is the correct syntax to code in the Pre-Create SQL Statement or Post Create SQL Statement for the Output Tool to achieve this?

[Zok]

Hello

Post create is the best way (the other way is to build a monstruosity that allows you to chose the primary key and create a script to create the table with the right primary key)

You find a famous topic here