Thank you so much, it works perfectly ... View more

varValue: 02F210 - varName: rATType varValue: '2' - varName: resultCode varValue: '2001' - varName: recordOpeningTime   this is the 1st resultcode present at starting   ... View more

hello, one stackoverflow answer suggested to configure property "Record Reader"-> "Csv Reader".  Property of Controller Service (Csv Reader), "Schema Access Strategy" to be "Use String Fields from header". This helped.  You are telling about Avro Schema. Could you please give some insights. How to configure that? Also I have one more different topic question. Say I have a file having 100 records. In this file I want to ignore the first line as it's data I do not want to process. I want to process from second line. How to do that? Thanks ... View more

Thanks a lot, @SAMSAL  for your detailed explanations. Appreciate your expertise on the NiFi. I am a beginner to the NiFi world and not much documentation on this topic is available on the internet. Thanks once again for your support! ... View more

Hi, Welcome to the community. Can you elaborate more on how you want to flatten the input specially when you have multiple arrays with different cardinalities where sometimes you match by index and other (when the array count = 1) you seem to assign to all. Also your sample input seem to have some matching values which makes it ambiguous  in figuring which value is being assigned to what array. When I look at the output all I see is  two identical objects where all the values seem to match which makes it even more confusing.  ... View more

Hey @SAMSAL - thanks for the detailed reply, and yep you hit the nail on the head ha ha. I've used a few of those links already, and as you said I was close, but not quite there. I grasp the concept, it's just the syntax of everything that was throwing me off. That being said, the JSLT example you posted does seem to make more sense to me also, so that's definitely something I'll look into. I spoke to a guy called Paul Lakus in the NiFi slack channel and he basically gave me almost exactly the same solution that you have posted and so I managed to work out how it was being done, but still a huge learning curve for me heh. Anyway this now seems to be working as intended, which I'm extremely grateful for so thank you for your input and the steer towards JSLT - definitely something to look into. Thanks!!   ... View more

@Adhitya, Did the response assist in resolving your query? If it did, kindly mark the relevant reply as the solution, as it will aid others in locating the answer more easily in the future. ... View more

@mburgess -- I am reading from Oracle table, not sure about the incoming flowfile ... View more

@mburgess @MattWho Hi! Do you have any insights here? Thanks. ... View more

hi @SAMSAL , i will test this process and return with more updates. ... View more