+6I'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.
Hi
A possible reason for the error is, there could be an empty cell in ID column within the File A. Check this point firstly.
+6Hi
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?
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.
+6No, 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😁
