Prabhu, I answered this question with an ExecuteScript example which will do what you are looking for on Stack Overflow [1].
[1] http://stackoverflow.com/a/41887397/70465 Andy LoPresto [email protected] [email protected] PGP Fingerprint: 70EC B3E5 98A6 5A3F D3C4 BACE 3C6E F65B 2F7D EF69 > On Jan 26, 2017, at 8:40 PM, prabhu Mahendran <[email protected]> wrote: > > Hi All, > > I have data in which i need to compare month of data if it is previous month > then it should be insert otherwise not. > > Example: > > 23.12.2016 12:02:23,Koji,24 > 22.01.2016 01:21:22,Mahi,24 > > Now i need to get first column of data (23.12.2016 12:02:23) and then get > month (12) on it. > > Compared that with before of current month like., > > If current month is 'JAN_2017',then get before of 'JAN_2017' it should be > 'Dec_2016' > > For First row, > > compare that 'Dec_2016' with month of data 'Dec_2016' [23.12.2016]. > > It matched then insert into database. > > if it not matched then ignore it. > > is it possible in nifi? > > Many thanks, > prabhu > > >
signature.asc
Description: Message signed with OpenPGP using GPGMail
