Hi Andy,
i have already tried with your alternative solution.
"UpdateAttribute to add a new attribute with the previous month value, and
then RouteOnAttribute to determine if the flowfile should be inserted "
i have used below expression language in RouteOnAttribute,
*${literal('Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec'):getDelimitedField(${csv.1:toDate('dd.MM.yyyy
hh:mm:ss'):format('MM')}):equals(${literal('Dec,Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov'):getDelimitedField(${now():toDate('
Z MM dd HH:mm:ss.SSS yyyy'):format('MM'):toNumber()})})}*
it could be failed in below data.,
*23.12.2015,Andy,21*
*23.12.2017,Present,32*
My data may contains some past years and future years
It matches with my expression it also inserted.
I need to check month with year in data.
How can i check it?
On Fri, Jan 27, 2017 at 10:52 AM, Andy LoPresto <alopre...@apache.org>
wrote:
> 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
> alopre...@apache.org
> *alopresto.apa...@gmail.com <alopresto.apa...@gmail.com>*
> PGP Fingerprint: 70EC B3E5 98A6 5A3F D3C4 BACE 3C6E F65B 2F7D EF69
>
> On Jan 26, 2017, at 8:40 PM, prabhu Mahendran <prabhuu161...@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
>
>
>
>
>
