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
