Skip to main content
  • EN

Hi all,

I have two CSV files (A and B) that I've included using CSV readers, and I need to join them using a feature joiner on a specific column. CSV A contains numbers in all rows, whereas CSV B has numerous <Null> cells in the column. When I run the feature joiner it fails. I already tried:

  • Changing both attribute types to number
  • I included attribute managers before each CSV to include letters with the numbers of each CSV file to force matching as text

Does anyone have any suggestions? 

Many thanks.

 

 

Hi ​@tullus ,

FeatureJoiner outputs features through the <Rejected> port, if a Join On attribute was <null>. It's an intentional behavior, see also the Help on FeatureJoiner.

Configuration / Output Ports / <Rejected>
Invalid features from any input port. Features will be rejected if a Join On value is missing or null.

 

If you want to continue the translation when a feature was rejected, try connecting a transformer e.g. Logger or Junction to the <Rejected> port.

Maybe the best strategy would be to filter those features without values (using a simple tester) before your FeatureJoiner

Thanks both. I filtered the features using the tester and then the feature joiner worked. Then I linked the other part of the tester to an Attribute Manager together with the feature joiner result. Kind of bypassed the <null> cells and them put them together in the process using the attribute manager. Worked well.

Community Stats

31,897
Posts
121,119
Replies
39,512
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.