Skip to main content
Question

Fill attribute values but not for all the records

  • June 23, 2020
  • 7 replies
  • 21 views

Hi. I have two datasets. One of them has 25562 records. The other one has 16310 and it contains the values for an attribute that I want to put in the larger dataset. I have tried with AttibuteMerger and Attribute Joiner, but the result is a dataset with only the 16310 records that both datasets share. How can I fill de 16310 records and keep the rest empty on the larger dataset? Thanks!

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.

7 replies

ebygomm
Influencer
Forum|alt.badge.img+46
  • Influencer
  • June 23, 2020

Just join up the unmerged requestor port back into your workflow

You could also use a FeatureJoiner instead and use a Left Join to return all the records from one dataset whether matched or not


david_r
Celebrity
  • June 23, 2020

The output port UnmergedRequestor will contain the remaining requestor features that did not find a match in the supplier dataset.


becchr
Influencer
Forum|alt.badge.img+33
  • Influencer
  • June 23, 2020

hi @juanrodriguezso, the other records are in the 'unmergedRequestor' port, no?

you can get them from there


As simple as that! :) Thank you all!


Just join up the unmerged requestor port back into your workflow

You could also use a FeatureJoiner instead and use a Left Join to return all the records from one dataset whether matched or not

So easy... :) Thanks!


hi @juanrodriguezso, the other records are in the 'unmergedRequestor' port, no?

you can get them from there

So easy.... :) Thanks!!!


The output port UnmergedRequestor will contain the remaining requestor features that did not find a match in the supplier dataset.

So easy... _) thanks!