Skip to main content
Solved

FeatureJoiner MISSING_LEFT_KEY


mohamedalsobh
Contributor
Forum|alt.badge.img+1

I'm trying to join two Excel files that share a common column called "ID".

File (A), which I consider the main file, has 7 columns. File (B) has 16 columns, but I only need one column from it, called "NON", to be added to file (A).

I tried using the FeatureJoiner, but it didn’t work. I also used the AttributeKeeper to filter the data, but the result is always null.

Note: The column titles in both Excel files are written in Arabic. is this could be the reason?

 

Best answer by takashi

No, ID duplication shouldn't be the reason for the error. 

Didn't you find an empty cell in ID column, File A?

According to the table shown in your screenshot, I guess that there is a row which has value 627 in the second column, but doesn't have ID value. Possibly 627 is the total of the second column values or something.

 

View original
Did this help you find an answer to your question?

4 replies

takashi
Influencer
  • April 25, 2025

Hi ​@mohamedalsobh ,

A possible reason for the error is, there could be an empty cell in ID column within  the File A. Check this point firstly.


mohamedalsobh
Contributor
Forum|alt.badge.img+1
  • Author
  • Contributor
  • April 25, 2025
takashi wrote:

Hi ​@mohamedalsobh ,

A possible reason for the error is, there could be an empty cell in ID column within  the File A. Check this point firstly.

I’ve discovered that file B has many duplicate values in the ID column. For example, the ID "MOO" appears two or more times in file B, while in file A, each ID is unique and only appears once. this could be the reason. Is there a good solution for that issue? 


takashi
Influencer
  • Best Answer
  • April 25, 2025

No, ID duplication shouldn't be the reason for the error. 

Didn't you find an empty cell in ID column, File A?

According to the table shown in your screenshot, I guess that there is a row which has value 627 in the second column, but doesn't have ID value. Possibly 627 is the total of the second column values or something.

 


mohamedalsobh
Contributor
Forum|alt.badge.img+1
  • Author
  • Contributor
  • April 25, 2025
takashi wrote:

No, ID duplication shouldn't be the reason for the error. 

Didn't you find an empty cell in ID column, File A?

According to the table shown in your screenshot, I guess that there is a row which has value 627 in the second column, but doesn't have ID value. Possibly 627 is the total of the second column values or something.

 

You're a hero! The number was linked to the total number of layers, but there was no description for it

However, I found that FME was reading 901 features, even though I only have 88. I fixed that using the Tester.

Another problem I faced was that duplicate ID in file B caused all its records to be added to file A. I solved that using the DuplicateFilter I’ve got the result I wanted thanks you made my day😁


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