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

achan

• October 23, 2008 00:00

• Answered

Follow

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

• 

  avackova

  • October 23, 2008 06:45

  0

  Comment actions Permalink

  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.
• 

  achan

  • October 30, 2008 18:39

  0

  Comment actions Permalink

  I got it working with your suggestion. Thanks!!

Please sign in to leave a comment.