How to count unique values when a particular node value is ERROR. The below is the xml source. there different data sets like SellOut, SellIn and Inventory but i want have a unique record count for the RECORD_TYPE=ERROR irrespective of data set type\[code\]<SellOutErrorRecord> <RECORD_TYPE>WARNING</RECORD_TYPE> <ERROR_DESC>record 1:location id is invalid</ERROR_DESC> <RECORD_NO>1</RECORD_NO> <LOCATION_NAME>XYZ el</LOCATION_NAME> <PRODUCT_NUMBER>336549R-001</PRODUCT_NUMBER> <PRODUCT_OPTION>0D1</PRODUCT_OPTION> <PRODUCT_LINE>LA</PRODUCT_LINE></SellOutErrorRecord><SalesInErrorRecord> <RECORD_TYPE>ERROR</RECORD_TYPE> <ERROR_DESC>record 1:location id is invalid</ERROR_DESC> <RECORD_NO>1</RECORD_NO> <LOCATION_NAME>XYZ el</LOCATION_NAME> <PRODUCT_NUMBER>336549R-001</PRODUCT_NUMBER> <PRODUCT_OPTION>0D1</PRODUCT_OPTION> <PRODUCT_LINE>LA</PRODUCT_LINE> <PRODUCT_LINE_TYPE>C</PRODUCT_LINE_TYPE></SalesInErrorRecord><SellOutErrorRecord> <RECORD_TYPE>ERROR</RECORD_TYPE> <ERROR_DESC>record 2:SO:invoiced net amount is invalid</ERROR_DESC> <RECORD_NO>2</RECORD_NO> <LOCATION_NAME>XYZ el</LOCATION_NAME> <PRODUCT_NUMBER>3X-KN73C-DB</PRODUCT_NUMBER> <PRODUCT_OPTION>0D1</PRODUCT_OPTION> <PRODUCT_LINE>HA</PRODUCT_LINE> <PRODUCT_LINE_TYPE>E</PRODUCT_LINE_TYPE></SellOutErrorRecord><SellOutErrorRecord> <RECORD_TYPE>ERROR</RECORD_TYPE> <ERROR_DESC>record 3:SO:transaction currency is invalid</ERROR_DESC> <RECORD_NO>3</RECORD_NO> <LOCATION_NAME>XYZ el</LOCATION_NAME> <PRODUCT_NUMBER>339112-B25</PRODUCT_NUMBER> <PRODUCT_OPTION>0D1</PRODUCT_OPTION> <PRODUCT_LINE>J3</PRODUCT_LINE> <PRODUCT_LINE_TYPE>E</PRODUCT_LINE_TYPE></SellOutErrorRecord><SalesInErrorRecord> <RECORD_TYPE>WARNING</RECORD_TYPE> <ERROR_DESC>record 3:SI:buy quantity is zero</ERROR_DESC> <RECORD_NO>3</RECORD_NO> <LOCATION_NAME>XYZ el</LOCATION_NAME> <PRODUCT_NUMBER>339112-B25</PRODUCT_NUMBER> <PRODUCT_OPTION>0D1</PRODUCT_OPTION> <PRODUCT_LINE>J3</PRODUCT_LINE> <PRODUCT_LINE_TYPE>E</PRODUCT_LINE_TYPE></SalesInErrorRecord><SalesInErrorRecord> <RECORD_TYPE>ERROR</RECORD_TYPE> <ERROR_DESC>record 3:SI:transaction document id is invalid</ERROR_DESC> <RECORD_NO>3</RECORD_NO> <LOCATION_NAME>XYZ el</LOCATION_NAME> <PRODUCT_NUMBER>339112-B25</PRODUCT_NUMBER> <PRODUCT_OPTION>0D1</PRODUCT_OPTION> <PRODUCT_LINE>J3</PRODUCT_LINE> <PRODUCT_LINE_TYPE>E</PRODUCT_LINE_TYPE></SalesInErrorRecord><SellOutErrorRecord> <RECORD_TYPE>WARNING</RECORD_TYPE> <ERROR_DESC>record 4:SO:invoiced net amount is invalid</ERROR_DESC> <RECORD_NO>4</RECORD_NO> <LOCATION_NAME>XYZ el</LOCATION_NAME> <PRODUCT_NUMBER>445860-B21</PRODUCT_NUMBER> <PRODUCT_OPTION>0D1</PRODUCT_OPTION> <PRODUCT_LINE>MV</PRODUCT_LINE> <PRODUCT_LINE_TYPE>C</PRODUCT_LINE_TYPE></SellOutErrorRecord><SalesInErrorRecord> <RECORD_TYPE>ERROR</RECORD_TYPE> <ERROR_DESC>record 5:SI:transaction currency is null or invalid</ERROR_DESC> <RECORD_NO>5</RECORD_NO> <LOCATION_NAME>XYZ el</LOCATION_NAME> <PRODUCT_NUMBER>339112-B25</PRODUCT_NUMBER> <PRODUCT_OPTION>0D1</PRODUCT_OPTION> <PRODUCT_LINE>J3</PRODUCT_LINE> <PRODUCT_LINE_TYPE>E</PRODUCT_LINE_TYPE></SalesInErrorRecord><InventoryErrorRecord> <RECORD_TYPE>ERROR</RECORD_TYPE> <ERROR_DESC>record 6
roduct id is invalid</ERROR_DESC> <RECORD_NO>6</RECORD_NO> <LOCATION_NAME>XYZ XYZ</LOCATION_NAME> <PRODUCT_NUMBER>331184-B21</PRODUCT_NUMBER> <PRODUCT_OPTION>0S1</PRODUCT_OPTION> <PRODUCT_LINE>R8</PRODUCT_LINE> <PRODUCT_LINE_TYPE>E</PRODUCT_LINE_TYPE></InventoryErrorRecord><SellOutErrorRecord> <RECORD_TYPE>ERROR</RECORD_TYPE> <ERROR_DESC>record 6:SO:invoiced net amount is invalid</ERROR_DESC> <RECORD_NO>6</RECORD_NO> <LOCATION_NAME>XYZ el</LOCATION_NAME> <PRODUCT_NUMBER>339112-B25</PRODUCT_NUMBER> <PRODUCT_OPTION>0D1</PRODUCT_OPTION> <PRODUCT_LINE>J3</PRODUCT_LINE> <PRODUCT_LINE_TYPE>E</PRODUCT_LINE_TYPE></SellOutErrorRecord>\[/code\]the output has to be record_count=5.Thanks for your help...
roduct id is invalid</ERROR_DESC> <RECORD_NO>6</RECORD_NO> <LOCATION_NAME>XYZ XYZ</LOCATION_NAME> <PRODUCT_NUMBER>331184-B21</PRODUCT_NUMBER> <PRODUCT_OPTION>0S1</PRODUCT_OPTION> <PRODUCT_LINE>R8</PRODUCT_LINE> <PRODUCT_LINE_TYPE>E</PRODUCT_LINE_TYPE></InventoryErrorRecord><SellOutErrorRecord> <RECORD_TYPE>ERROR</RECORD_TYPE> <ERROR_DESC>record 6:SO:invoiced net amount is invalid</ERROR_DESC> <RECORD_NO>6</RECORD_NO> <LOCATION_NAME>XYZ el</LOCATION_NAME> <PRODUCT_NUMBER>339112-B25</PRODUCT_NUMBER> <PRODUCT_OPTION>0D1</PRODUCT_OPTION> <PRODUCT_LINE>J3</PRODUCT_LINE> <PRODUCT_LINE_TYPE>E</PRODUCT_LINE_TYPE></SellOutErrorRecord>\[/code\]the output has to be record_count=5.Thanks for your help...