Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Roy,
I think you have to add a subjob collecting the '.bad' files and aggregate that list into a single output.
tfilelist---->tfileinputdelimited---->tschemacompliancecheck---->tmap---->tmysqloutput---->tfilecolpy---->
on subjob ok -> tfilelist -> titeratetoflow -> taggregaterow -> tsendmail
To do this you need to to change the file iterator to a flow using the tInterateToFlow component. This flow can be used in a tAggregateRow component:
In the tIterateTolow component define the elements you want to use (at least 2 because you need an extra parent level to do the aggregation). For example:
Column: Folder / Value: ((String)globalMap.get("tFileList_1_CURRENT_FILEDIRECTORY"))
Column: File / Value: ((String)globalMap.get("tFileList_1_CURRENT_FILE"))
In the aggregation group by 'Folder' field and perform a 'list' operation on the 'Filename' field
The out put of the tAggregateRow is a Filename field containing the list of filenames!
Regards, Rolf.
I think you have to add a subjob collecting the '.bad' files and aggregate that list into a single output.
tfilelist---->tfileinputdelimited---->tschemacompliancecheck---->tmap---->tmysqloutput---->tfilecolpy---->
on subjob ok -> tfilelist -> titeratetoflow -> taggregaterow -> tsendmail
To do this you need to to change the file iterator to a flow using the tInterateToFlow component. This flow can be used in a tAggregateRow component:
In the tIterateTolow component define the elements you want to use (at least 2 because you need an extra parent level to do the aggregation). For example:
Column: Folder / Value: ((String)globalMap.get("tFileList_1_CURRENT_FILEDIRECTORY"))
Column: File / Value: ((String)globalMap.get("tFileList_1_CURRENT_FILE"))
In the aggregation group by 'Folder' field and perform a 'list' operation on the 'Filename' field
The out put of the tAggregateRow is a Filename field containing the list of filenames!
Regards, Rolf.