topic Re: Renaming files from Local server in Talend Studio

Renaming files from Local server

sushantk19 — Fri, 15 Nov 2024 23:44:20 GMT

Hello,

I recieve 3 csv files at my local shared drive:

qppxg6dy3oqo_2021-09-14T100000_8fd9627ba6f33235446f8fcb88ca7891_2853a9.csv

qppxg6dy3oqo_2021-09-14T100000_8fd9627ba6f33235446f8fcb88ca7891_be822a.csv

qppxg6dy3oqo_2021-09-14T100000_8fd9627ba6f33235446f8fcb88ca7891_c3575d.csv

I have to rename 1st file as File1.csv, 2nd one as File2.csv & 3rd one as File3.csv so that i can process them through the same ETL. The file name is not static here as every hour we recieve these files from out customer.

Can you guide what components in Talend that i can use to achieve the same?

Re: Renaming files from Local server

manodwhb — Tue, 14 Sep 2021 12:59:45 GMT

@Sushant Kapoor , you can check the below scenario to rename the files.

https://help.talend.com/r/UnUtyrKpHkBWzBHzA4PPYg/1jIg2GLSxzginFRAMCzFzw

Thanks,

Manohar

Re: Renaming files from Local server

sushantk19 — Tue, 14 Sep 2021 13:11:14 GMT

@manodwhb: i read about this. why do i get the below error even though i have 3 files at the location:

[statistics] connecting to socket on port 4015

[statistics] connected

[ERROR] 15:08:17 .job_000_adjust_20210914_0_1.job_000_Adjust_20210914- The source File "qppxg6dy3oqo_2021-09-14T100000_8fd9627ba6f33235446f8fcb88ca7891_2853a9.csv" does not exist or is not a file.

[ERROR] 15:08:17 .job_000_adjust_20210914_0_1.job_000_Adjust_20210914- tFileCopy_1 qppxg6dy3oqo_2021-09-14T100000_8fd9627ba6f33235446f8fcb88ca7891_2853a9.csv

[ERROR] 15:08:17 .job_000_adjust_20210914_0_1.job_000_Adjust_20210914- The source File "qppxg6dy3oqo_2021-09-14T100000_8fd9627ba6f33235446f8fcb88ca7891_be822a.csv" does not exist or is not a file.

[ERROR] 15:08:17 .job_000_adjust_20210914_0_1.job_000_Adjust_20210914- tFileCopy_1 qppxg6dy3oqo_2021-09-14T100000_8fd9627ba6f33235446f8fcb88ca7891_be822a.csv

[ERROR] 15:08:17 .job_000_adjust_20210914_0_1.job_000_Adjust_20210914- The source File "qppxg6dy3oqo_2021-09-14T100000_8fd9627ba6f33235446f8fcb88ca7891_c3575d.csv" does not exist or is not a file.

[ERROR] 15:08:17 .job_000_adjust_20210914_0_1.job_000_Adjust_20210914- tFileCopy_1 qppxg6dy3oqo_2021-09-14T100000_8fd9627ba6f33235446f8fcb88ca7891_c3575d.csv

[statistics] disconnected

Re: Renaming files from Local server

manodwhb — Tue, 14 Sep 2021 13:36:23 GMT

@Sushant Kapoor ,please check the below screenshot and it was working as expected and you need to check the configuration of tFilecopy.