Skip to main content
Question

Aggregator, not Merge Incoming Attributes

  • August 1, 2018
  • 3 replies
  • 76 views

hlouie
Contributor
Forum|alt.badge.img+16

Table of attributes I want to merge with Group By: FILENAME

Input

Aggregator

Output

Desire

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

3 replies

takashi
Celebrity
  • 7843 replies
  • August 1, 2018

The output is correct, since <null> is a value. Consider using the NullAttributeMapper to remove all <null> values (i.e. change to <missing>) to get the desired result.


hlouie
Contributor
Forum|alt.badge.img+16
  • Author
  • Contributor
  • 33 replies
  • August 1, 2018

The output is correct, since <null> is a value. Consider using the NullAttributeMapper to remove all <null> values (i.e. change to <missing>) to get the desired result.

Success, the fields need's to be "MISSING", NULL and BLANK don't work.

 

Thank-you

 

 


takashi
Celebrity
  • 7843 replies
  • August 1, 2018

The output is correct, since <null> is a value. Consider using the NullAttributeMapper to remove all <null> values (i.e. change to <missing>) to get the desired result.

Good to hear.

 

<empty> is a string value consisting of no characters; <null> is a special value indicating that the attribute exists but it doesn't have a valid value; <missing> indicates that the attribute does not exist.