Capturing file information

Another useful Talend feature is the ability to capture information about a file for use within downstream processing, most probably to perform validation prior to processing.

Getting ready

Open the jo_cook_ch08_0110_fileInformation job.

How to do it...

The steps for capturing file information are as follows:

1. Drag a tFileProperties component from the right-hand panel. Open tFileProperties, and set the file name to context.cookbookData+"/chapter8/chapter08_jo_0110_customerData.txt".

2. Drag tFlowToIterate to the canvas, and link the row from tFileProperties to it. Name the flow properties.

3. Drag tFileRowCount to the canvas and set the filename to match the tFileProperties component.

4. Add onSubjobOk from tFileProperties to tFileRowCount, and then to tFixedFlowInput, so that your job looks like the one shown as follows:

   

5. Open tFixedFlowInput.

6. Add ((Long)globalMap.get("properties.size")) to the field fileSize.

7. Add ((Integer)globalMap.get("tFileRowCount_1_COUNT")) to the field numberOfRows...