topic MYSQL Primary Key in Talend Studio

MYSQL Primary Key

Anonymous — Wed, 25 Apr 2018 22:36:35 GMT

Hi guys, im working with the component tAmazonMysqlOutput, and when i try to upload a table to it from one of my excels it asks me for a primary key.

How can i tell the component to generate a row from 1 to whatever number of rows i insert from my excel and use it as a primary key?

Because the columns of the excel im working on dont have an id which i can use for the primary key.

Ty !

Re: MYSQL Primary Key

TRF — Wed, 25 Apr 2018 23:01:23 GMT

If you don't have a natural pk in your Excel file, you may add one when you read the file using a sequence in a tMap or tJavaRow.

Re: MYSQL Primary Key

Anonymous — Wed, 25 Apr 2018 23:09:34 GMT

Can you show me a quick demo or some pics? im new with talend dont know how to do that

Re: MYSQL Primary Key

vapukov — Thu, 26 Apr 2018 03:25:25 GMT

@gonzalogtzwrote:

Hi guys, im working with the component tAmazonMysqlOutput, and when i try to upload a table to it from one of my excels it asks me for a primary key.

How can i tell the component to generate a row from 1 to whatever number of rows i insert from my excel and use it as a primary key?

Because the columns of the excel im working on dont have an id which i can use for the primary key.

Ty !

would be better, if You first show, HOW it is:

it asks me for a primary key.

Re: MYSQL Primary Key

Anonymous — Thu, 26 Apr 2018 15:18:45 GMT

I got it, Thanks!