How to execute multiple SQL queries in PutSql processor at a time Ex: insert into table_a values('test_1'); insert into table_b values('test_2'); Flow:GetFile -> ReplaceText -> PutSQL -> PutFile In the above flow ReplaceText processor will replace the flow file with above example query. With this SQL flow file PutSql processor getting triggered and failed with error. ... View more

Hi Team, I have a requirement Where i have to extract first 5 records from a file(Sample.CSV, This file contain 100 rows and 5 column for each row) Out of 5 record, each record of the 2nd column contain value as "Yes" then I want add a ATTRIBUTE for that file "Is_valid=Y" else "Is_valid=N" Ex: India,YES,Asia USA,YES,USA UK,YES,UK India1,YES,Asia USA1,YES,USA I did following flow, It is working for record level. GetFile -> Split Line -> Extract Text -> RouteOnAttribte -> UpdateAttribute But I dont want to do this check for all the record, I need to do this check only for first 5 record and assign the Valid flag for that file. Please help me on this. ... View more

Hi Team, I have requirement like need to read the environment property file and keep in memory, also need to auto refresh is any update done in property file. Example Env.properties parent_path = /sourcesystem/country/ Auth_key = 234234fsdaf234 password =************** IN = india i need to use the above property in my processor across the flow. Example in ListFile processor i want to use ${parent_path} , this should replace "/sourcesystem/country/ " value. ... View more