# Denormalizer: how to deal with some keys having null value?

**URL:** <https://forum.cloverdx.com/t/denormalizer-how-to-deal-with-some-keys-having-null-value/425>\
**Category:** CloverDX Platform\
**Created:** [October 23, 2008, 12:00am UTC](https://forum.cloverdx.com/t/denormalizer-how-to-deal-with-some-keys-having-null-value/425 "2008-10-23T00:00:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![achan](https://avatars.discourse-cdn.com/v4/letter/a/7cd45c/32.png) [@achan](https://forum.cloverdx.com/u/achan)\
**Post date:** [October 23, 2008, 12:00am UTC](https://forum.cloverdx.com/t/denormalizer-how-to-deal-with-some-keys-having-null-value/425/1 "2008-10-23T00:00:00Z")

</div>

Hi,

let’s say I have a Denormalizer key = “acct\_no; address; phone”, and if my data is:

acct\_no, address, phone, name  
1, “100 A. St, SF, CA 94111”, , Adam  
1, “100 A. St, SF, CA 94111”, , Alex

they should be denormalized to just 1 output… but Clover is creating me an output with these 2 records…

how can i use the Denormalizer to create just 1 record based on my key?

Thanks,  
al

---

<div class="post-metadata">

**Author:** ![avackova](https://avatars.discourse-cdn.com/v4/letter/a/65b543/32.png) [@avackova](https://forum.cloverdx.com/u/avackova)\
**Post date:** [October 23, 2008, 6:45am UTC](https://forum.cloverdx.com/t/denormalizer-how-to-deal-with-some-keys-having-null-value/425/2 "2008-10-23T06:45:08Z")

</div>

Hello,  
you can’t do that in Denormalize node. The workaround could be setting “phone” field as not nullable with default value (eg. “unknnown” ) and then strip this value in Denormalizer.

---

<div class="post-metadata">

**Author:** ![achan](https://avatars.discourse-cdn.com/v4/letter/a/7cd45c/32.png) [@achan](https://forum.cloverdx.com/u/achan)\
**Post date:** [October 30, 2008, 6:39pm UTC](https://forum.cloverdx.com/t/denormalizer-how-to-deal-with-some-keys-having-null-value/425/3 "2008-10-30T18:39:36Z")

</div>

I got it working with your suggestion. Thanks!!