nifi-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andy LoPresto <alopre...@apache.org>
Subject Re: Past month data insertion is possible
Date Fri, 27 Jan 2017 05:22:03 GMT
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
alopresto@apache.org
alopresto.apache@gmail.com
PGP Fingerprint: 70EC B3E5 98A6 5A3F D3C4  BACE 3C6E F65B 2F7D EF69

> On Jan 26, 2017, at 8:40 PM, prabhu Mahendran <prabhuu161994@gmail.com> 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
> 
> 
> 


Mime
View raw message