Fetching & Running Multiple Sub Xactions

Steps for running multiple xactions within xaction..

1. Create one xaction file with Solution,Path as Process Inputs.
2. Create a Relation component for the query SELECT filename from where SUBSTRING_INDEX(pro_files.fileName,'.',-1)="xaction". The where clause will pick only xaction files from the column in the table. Pass the column name to Result-Set Columns.
3. Create a Action Loop and pass the query result set to it.
4. Create a Pentaho BI Process pass Solution and path from the Process Input. Pass the query column name in the XAction Name.
5. Set the output as desired for the sub XAction files.
This will execute all XAction files one by one.