Set Value with multiple conditions

Hi Enrique,

From the description you have I believe the method you are using should work.

To test this I created a csv file with 2 columns:

a,

b,

c,

d, 

I then fed this into a DPA report using the ReadCSV data source and confirmed that I had a report output that looked like:

Letter     Number

a

b

c

d

I then attached that to a SetValue operator and added a condition where Letter was equal to a, set the Number field equal to 1. I then attached another Setvalue operator and added a condition where Letter was equal to b, set the Number field equal to 2. These were both displayed correctly in the report output.

The only reason I can think of why this wouldn't work in your example would be if your 4 rows containing a,b,c and d weren't actually unique rows, but were actually contained within a single element in the xml data. If this was the case then you would see a "Noted" column in your report. If you do see this then it means that your 4 rows aren't unique and have the same values for the key fields. When data isn't unique, although the output in the report looks like separate rows, the multiple values for the same key values are actually stored as a list within the same element in the xml.

If the above isn't the case please can you export your report definition from the report editor, change the file extension to a .html file (as .xml isn't allowed to be attached) and add a reply to this discussion and attach the report definition? I can then take a look and see if I can work out why it isn't working.

Thanks

David

David Russell

EMC Technical Support