COUNT(EXTRACT(objects, value:objects = "1"))
I used this rule in a single occurrence output. If the value of the first object is "1", then the final output is 1. If the value of the first object is NOT "1", then the final output is 0, regardless what value is for the 2nd or 3th object.
Anyone have ideas about this issue. Or I just made some mistakes.
This topic has been locked.
1 reply Latest Post - 2013-03-30T17:13:53Z by SystemAdmin
Pinned topic Extract Function
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2013-03-30T17:13:53Z at 2013-03-30T17:13:53Z by SystemAdmin
SystemAdmin 110000D4XK6184 PostsACCEPTED ANSWER
Re: Extract Function2013-03-30T17:13:53Z in response to SystemAdminhi,
If you need only first object you can use a simple IF condition by indexing this element.
Use a look up function. so that it doesn't bother the second or third. Again if you need to check only the very first object then go for the simple if and index.