Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
@Sushant Kapoor ,please check the below screenshot and it was working as expected and you need to check the configuration of tFilecopy.
@Sushant Kapoor , you can check the below scenario to rename the files.
https://help.talend.com/r/UnUtyrKpHkBWzBHzA4PPYg/1jIg2GLSxzginFRAMCzFzw
Thanks,
Manohar
@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
@Sushant Kapoor ,please check the below screenshot and it was working as expected and you need to check the configuration of tFilecopy.