Following Kettle job was design to generate survey result file and statistic file. This job loop through several folders and export output into a csv file, then send it to a FTP site.
In file tab,a local directory is needed to be given instead of a file path or mapped directory. In wildcard area, file name or regular expression to pick up the right files needed to be given.