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

[Anonymous]

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.

[Anonymous]

You can use tMap or tJavaRow component.

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

[bhagyarekha]

Hi

As dgm said i agree

plz find attachment images

out.JPG
newcolumn.JPG

[Anonymous]

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

[bhagyarekha]

Hi

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

[Anonymous]

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.

[bhagyarekha]

Ok