Question

Left Outer Join and maintain record order

  • 22 November 2021
  • 1 reply
  • 6 views
R

I have 2 readers. I am trying to add new fields and values from the 2nd reader to the 1st reader if there is a match. There isn't always a match and I want to keep the order of the records in the output. I'm trying both featuremerger and feature joiner but neither are reproducing what I expect.

Job_Line_exampleThe featurejoiner failed because not all job records have a lineID. I still want all jobs in the output.

One note is there the Lines have a 1:M relationship with Jobs. There is only 1 line record that would populate the output new fields.

Thanks!

1 reply

R

For anyone wondering, I followed this workflow with NullAttributeMapper:

https://community.safe.com/s/question/0D54Q000080hfLU/question-of-the-week-merging-data-with-the-featurejoiner

Line_Job_Tree solutionI had to set null keys to "NONE" before FeatureJoiners and then set them to null after the join.

Reply


Community Stats

28,669
Posts
109,357
Replies
36,531
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.