Skip to main content
Question

Left Outer Join and maintain record order

  • November 22, 2021
  • 1 reply
  • 56 views

rtreecare
Contributor
Forum|alt.badge.img

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

rtreecare
Contributor
Forum|alt.badge.img
  • Author
  • Contributor
  • November 22, 2021

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


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