I'm aiming to compare the values of multiple tables from two different data sources with FME. I've already prepared two tables, that list all values from either data source.

The 'left data source', consisting of two tables (Fruit and Vegetable) and their values over various columns:

IdLeftTableNameLeftColumnNameLeftValue1FruitNameApple1FruitColorRed1FruitKcal522FruitNameBanana2FruitColorYellow2FruitKcal893VegetableNameCarrot3VegetableColorOrange3VegetableShapePointy

 

The 'right data source', consisting of two tables (FRUITS and VEGETABLES) and their values over various columns:

IdRightTableNameRightColumnNameRightValue1FRUITSDESCRIPTIONApple1FRUITSCOLORYellow1FRUITSCALORIES522FRUITSDESCRIPTIONBanana2FRUITSCOLORYellow2FRUITSCALORIES903VEGETABLESDESCRIPTIONCarrot3VEGETABLESCOLOROrange3VEGETABLESSHAPEPointy

 

The tables and columns of both data sources can be related using the following mapping:

LeftTableNameLeftColumnNameRightTableNameRightColumnNameFruitNameFRUITSDESCRIPTIONFruitColorFRUITSCOLORFruitKcalFRUITSCALORIESVegetableNameVEGETABLESDESCRIPTIONVegetableColorVEGETABLESCOLORVegetableShapeVEGETABLESSHAPE

 

How can I implement the above mapping to compare the values from both data sources? The desired result looks like this:

IdLeftTableNameLeftColumnNameLeftValueRightValue1FruitNameAppleApple1FruitColorRedYellow1FruitKcal52522FruitNameBananaBanana2FruitColorYellowYellow2FruitKcal89903VegetableNameCarrotCarrot3VegetableColorOrangeOrange3VegetableShapePointyPointy