[statistics] connecting to socket on port 3710 [statistics] connected Exception in component tFileTouch_1 java.io.IOException: The system cannot find the path specified at java.io.WinNTFileSystem.createFileExclusively(Native Method) at java.io.File.createNewFile(Unknown Source) at recon_test.mutiple_folder_creation_0_1.mutiple_folder_creation.tFileInputDelimited_1Process(mutiple_folder_creation.java:1535) at recon_test.mutiple_folder_creation_0_1.mutiple_folder_creation.runJobInTOS(mutiple_folder_creation.java:1951) at recon_test.mutiple_folder_creation_0_1.mutiple_folder_creation.main(mutiple_folder_creation.java:1795) [statistics] disconnected Job mutiple_folder_creation ended at 16:17 09/08/2017. [exit code=1]
Could you please check your local talend and share the job? would be very helpful.
First, why is row2.newColumn1 being used when you were creating the folder using a tSystem component? Also, why when you are using row2.newColumn2, are you prefixing it with "C:/Users/DELL PC/Desktop/reports/SOURCE FILE 3/"?
OK, I have been through the complete thread again and I have some questions.
1) Is your data coming from Oracle? If so, why have you been reading from a file in some of the screenshots?
2) Are you expecting to create multiple Excel files per job or just one? For example, will the data being returned from your query require more than one output Excel file?
1) Is your data coming from Oracle? If so, why have you been reading from a file in some of the screenshots?
Ans: I tried both source as oracle and excel file.
Reason: 1) I am trying create folder initial process only then i need source as excel file and no target i want store txn_dt in context variable.(why means i will use this context variable create folder based on date anywhere in the job)
2) After some sub jobs, i am going to use oracle as source and target is excel files.
Note: You consider Oracle as source(Final point)
2) Are you expecting to create multiple Excel files per job or just one? For example, will the data being returned from your query require more than one output Excel file?
Ans: Yes per job.
flow: tOracleInput_1(Source) ==> tExcelOutputFile_1(Target) --- (multiple folder creations inside records based on unique txn_dt)
OK. This is a bit more complex. I think this could be a good learning opportunity, so I will give you the components and the order.....but you will need to try it and debug it. This solution WILL work, but only once you have ironed out any bugs that are introduced while building it.
1) Your first tOracleInput will return a distinct list of the data your files are grouped by. I believe that to be dates. Nothing else it required here.
2) Use the tJavaRow (or a tMap if your prefer) to create the file path from the group key. Output this to the tFlowToIterate.
3) Your tFlowToIterate will create a globalMap variable with that group key and the file path.
4) Connect your tFlowToIterate to another tOracleInput using an iterate link. This tOracleInput will return all of the data and be filtered by the group key derived in the first tOracleInput. You can use the globalMap variable in the WHERE clause of the tOracleInput.
5) The tFileOutputExcel will need to use the globalMap value for the file path.
The reason for doing it this way is that you will need to create a new file for each chunk of data requiring a new file. This cannot be done in one subjob. Therefore you need to iterate over that data. The tFlowToIterate will carry out the iteration and your second tOracleInput will supply the relevant data according to the key of the current iteration.
