Multiple lines of data on "Extra Information"
Summary
Pulling data from extra information, appears to produce duplicate lines when changes are madeContent
Hi
I'm trying to build a report using the Personal / Extra Information fields; where it is recorded if employee has a disability or is a member of a minority group. In instances where a "Y" value is recorded, it appears the report is returning 2 lines of data, one for the initial "N" on record and one for the "Y" update. Is there a way I can get the "Y" to over-ride the "N?
Thanks
Version
18CCode Snippet
<saw:report xmlns:saw="com.siebel.analytics.web/report/v1.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:sawx="com.siebel.analytics.web/expression/v1.1" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlVersion="201201160"> <saw:criteria xsi:type="saw:simpleCriteria" subjectArea=""Workforce Management - Worker Assignment Real Time"" withinHierarchy="true"> <saw:columns> <saw:column xsi:type="saw:regularColumn" columnID="c1d1c12acd0963513"> <saw:columnFormula> <sawx:expr xsi:type="sawx:sqlExpression">"Worker"."Person Number"</sawx:expr></saw:columnFormula></saw:column> <saw:column xsi:type="saw:regularColumn" columnID="c8bea188bd78339ea"> <saw:columnFormula>
0