Skip to main content
Question

Fill attribute values but not for all the records


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!

7 replies

ebygomm
Influencer
Forum|alt.badge.img+38
  • 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+26
  • 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!


ebygomm wrote:

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!


becchr wrote:

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

you can get them from there

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


david_r wrote:

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

So easy... _) thanks!


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings