topic Re: how to add extra columns while loading data from a file in s3 to table in Talend Studio

how to add extra columns while loading data from a file in s3 to table

Anonymous — Mon, 20 May 2019 11:22:16 GMT

Hi,

I am trying to load data into redshift tables from a csv file placed in S3. I want to add 2 more columns to this file and then load into target table. I am unable to use tmap here. Is there any other component/way to achieve this.

Thanks in advance!

Alekhya.

Re: how to add extra columns while loading data from a file in s3 to table

Anonymous — Mon, 20 May 2019 14:00:15 GMT

You can use tMap or tJavaRow component.

If you encounter any other issue, don't hesitate.

Re: how to add extra columns while loading data from a file in s3 to table

bhagyarekha — Tue, 21 May 2019 07:49:56 GMT

As dgm said i agree

plz find attachment images

out.JPG
newcolumn.JPG

Re: how to add extra columns while loading data from a file in s3 to table

Anonymous — Tue, 21 May 2019 08:15:20 GMT

Hi,

PFA.

I am loading the data from a file which is placed in S3 using tS3Put component. Now, I want to create table using tDBBulkExec where I need to add new columns.

I tried to add using tJavaRow but i am unable link it from tS3Put component.

Thanks,

Alekhya.

talend.png

Re: how to add extra columns while loading data from a file in s3 to table

bhagyarekha — Tue, 21 May 2019 08:38:18 GMT

Here to load the data into database first you need to get the data right,use ts3get after ts3put.As of my knowledge we need to get the data to load or to perform any operation

Regards

rekha

Re: how to add extra columns while loading data from a file in s3 to table

Anonymous — Tue, 21 May 2019 08:41:55 GMT

Hi,

You can load the data from the file directly into table without usig ts3get here as I am using BulkExec componet. I can give the details of the file in s3 over there.

Re: how to add extra columns while loading data from a file in s3 to table

bhagyarekha — Tue, 21 May 2019 08:44:44 GMT