Process the file and then delete it

One of the typical uses-cases is when you want to extract/load the file and then delete it. 

Use the following technique to bandle file processing and deleting the file:

Step 1. Create a source connection.

Step 2. Create a flow which reads the source file and transforms it to any destination.

Step 3. When creating the flow, select a transformation, click the Mapping button and open the Parameters tab.

Step 4. Enter the following JavaScript code into the After Extract field.

importPackage(com.toolsverse.config);

SystemConfig.instance().getProperties().put('unique_key', 
FilenameUtils.getName(dataSet.getFileNameToRead()));

this code stores the source filename under system properties. Use any unique key in place of 'unique_key', for example {json2csv}.

Step 5. Create a delete files flow.

Step 6. When creating a Delete file flow, select the connection created in Step 1, and enter a curly-brackets{} enclosed key, which was created in Step 4, into the FROM field. For example: {json2csv}.

Step 7. Create a nested flow which combines the flows created in Steps 2-4 and Steps 5-6.