Set Value fails to work

Question

I am merging several streams of data and I want to rename the value of the Status field when it is empty. I have tried using Set Value with a condition Status is Missing and then changing the Status field to a Static Value. However it does not replace the empty value. I have also tried changing the condition to Status is present and rather bizarrely it still does not change it for these fields!?!

How can a field not be either there or not there? Is anyone able to explain this weird logic which DPA appears to be operating under?

ElvinKan · Accepted Answer

What version of DPA are you using ? On the Fields tab of the datasource, you can double-click on the "Label" of the field and alter the fieldname there.

Also, there is a "Null Value" property of the field where you can set/initialise the field with a value in the event the field contains a Null value.

David_Hampson_90e289 · Answer

An update on this; I worked around this by adding an Add Field (Status set to dummy value x) prior to the merge, it seems the behaviour for an identically named field in a merge is to keep the entry from the left data source; after this I rename any Status entries equal to 'x'

David_Hampson_90e289 · Answer

Hi Elvin

We are using 5.5.1

I have just copied my data into a blank report and if I set the report to replace the null value in the Fields tab it is successful. I also replaced several steps to rename the field using the Label option there and that also worked successfully.

Thanks for your help again!

David

David_Hampson_90e289 · Answer

Of course you did not explain why the Rename Field operator did not work!  Perhaps it does not deal with null values very effectively?

Data Protection Advisor

Set Value fails to work

Was this post helpful?