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

CloverDX Platform
1

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

2

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.

3

I got it working with your suggestion. Thanks!!