A tool that fully combines two attribute tables with keeping the unmatched records,
In the screenshot below, I wanted to combine V1 and V3 tables based on V1 and V3 fields and to have the result as shown in the excel file (in the same screenshot).
How this might be performed?
I got that this tool is available in the FME “FeatureMerger”
this is the default behaviour
When joining tables, the default option is to keep all records. If a record in the target table doesn't have a match in the join table, that record is given null values for all the fields being appended into the target table from the join table.
whether using the Add Join tool in
so if the join doesn't work one way, switch the direction of the join. If you don't like it that way, save the joined file as a separate file and join it back to the file you want the join to go to.
PS moved to Managing Data space
I’m aware of using multiple tools to do this sort of work. However, my intent is to find one single tool that can do the job.
There isn't one, just the join and the results are directional, and you would have to create a model (or a script) to emulate the workflow that I suggest should the intended results not be to your satisfaction or expectations.