Loading data into excel file

[shalinim1]

Hi,

I have a source file where data got added for every time the job runs. I wanted to load that source to excel file. My job follows,

tfileinputdelimited--> tmap--> tfileoutputexcel

I have added a date column in tmap and getting it with the help of talend date generator.

I want the new data to be loaded in outputfile by remaining the existing data from source and generated date in tmap.

for example,

source data is,

1,abc

2,fgr

using tmap I have included the date and time and loaded to output table,

1,abc,2020-11-02 5:21:20

2,fgr,

2020-11-02 5:21:20

If the data is added to source as,

1,abc

2,fgr

3,ytr

by the time

2020-11-02 5:51:40

the output file should be,

1,abc,2020-11-02 5:21:20

2,fgr,

2020-11-02 5:21:20

3,ytr,

2020-11-02 5:51:40

But now its loading in output file as,

1,abc,2020-11-02

5:51:40

2,fgr,

2020-11-02 5:51:40

3,ytr,

2020-11-02 5:51:40

[shalinim1]

Thank you ​so much @Vikram Kumar​ .. Will try this 😊

[vikramk]

Hi @Shalini M​ ,

Would you mind marking it as solution once done, if it helps your requirement.