Please check if it is correct... I think that is better for you understand
STEP 1 (UNZIP ALL FILES)
tFileList to tFileUnarchive >> Iterate connection
STEP 2 (LOAD ALL CSV´S FILES TO DB)
PARENT JOB
Contexts:
filename, type String
tablename, type String
directory, type Directory
tFileList (Specify the directory the Value field of variable directory)
tIterateToFlow (Add column named filename and the Value field of the Mapping table with the CURRENT_FILE (variable generated by the tFileList))
tFixedFlowInput (Add two columns file_name and table_name and configure file-to-table mappings.
tMap
1-Drag the filename column of table row1 (from the tIterateToFlow), drop it onto file_name column of table row2 (from the tFixedFlowInput) to join the two tables for file name look-up.
2-Drag the filename column of table row1 and drop it onto the filename column of table out.
3-Drag the table_name column of table row2 and drop it onto the tablename of table out
4-Match Model to Unique match and Join Model to Inner Join
tJavaRow (codes: context.tablename = out.tablename and context.filename = out.filename.
tRunJob (select the child Job you want to call from the Repository)
CHILD JOB
Contexts:
filename, type String
tablename, type String
directory, type String
TFileInputDelimited
add column data and set type to Dynamic
File name/Stream - set variable to context.directory+context.filename
tDBOutput
Connection details ( including the host name or IP address, the port number, and database name).
Fill Table field with context variable defined for the table name+context.tablename.
Action on table list, select Default.
Action on data list, select Insert.
Click Sync columns to ensure the schema is the same as input component: single column named data, type Dynamic.
