Hello I have a bunch of XML files which I transform then I evaluate the XPATH to get the [Please refer to the NIFI flow] Each file consist of a single record which needs to inserted to the database.
At the moment flow processor is as follows:: ListFiles > FetchFile > TransformXml > EvaluateXpath > ReplaceText > PutSql.. In short, after transformation is done, i pick data i need as in image. Then create my custom insert statement for the query. Then i load the data into the database. My question is i have thousand of files which I need to transform and load in the database. So The PutSql Processor is inserting one file at a time.. I am not sure how to go about and load n files using sql.args.N.args and sql.args.N.value. Please advice on how to insert a batch of hundreds of files in one insert statement. Regards -- NOEL ALEX MAKUMULI
