Mapping Help required in Node count

[former_member1275317]

Hi Friends,

i need to count the number of occurences of source node. i'm able to count the occurences.

but i have some problem with this node. Source node happens only some times.

Source node.

<Event>

type- attribute

<Date>20092509</Date>

</Event>

Sometimes Event tag comes as </Event> without any type value then i need to pass " 0 " value.

Cases :

1. if empty Event tag happens then need to Pass "0"

2. <Event>

type

<Date></Date> in this case also need to pass 0.

3. <Event>

type "Order"

<Date>20092509</Date>

</Event>

<Event>

type "Delivery"

<Date>20092509</Date>

</Event>

in this case need to pass node count as "2"

please suggest me on this;

Regards,

Deeps

[Former Member · Accepted solution]

Hi,

One option is to count the attribute.

Other option is using if like if event exists and date exists and date length is greater than zero then count else count 0.

Regards,

---Satish

[Former Member]

use the mapping follows

                               event---->count...>map to then\
type------>equalS----->not----->AND--------------------->IFTHENELSE....> target fiels
    constant[]/            
                                       constant[0] map  to else/
Date----->equalS----->not----->map  to AND
  constant[]/

[jyothi_anagani]

Hi sandeep,

Map like this..

                     Date--\
                           then
Date---->NotEquals---->if          -----\
 Constant[]/                             \
                          else            \
            Constant[0]/                   \
                                         then
Date----->Exisists---->if--------        ----->Output
                                        else
                           Constant[0]/

I tested this...

Working Fine...

Thanks.

[former_member187339]

Hi,

Use like this

type--->exists \ Constant (0)

\ then /

\ /

or if -

---

> output

type --> equals "" / else(count) Event

Regards

Suraj

[Former Member]

did you tried the count function available ?

Rajesh

[Shabarish_Nair]

in your case since the conditions are as such its better to count the occurrences of the date field. Shouldn't that work?