Combine two or more tables

CloverDX Platform
1

Hi everyone.

I have some tables, like:

City | Schools
-----------------------
Chieti | 604
L’Aquila | 498
Pescara | 387
Teramo |430

City | Companies | Cattle
-----------------------------
Chieti | 3025 | 46684
L’Aquila | 5213 | 89456
Pescara | 3152 | 47507
Teramo | 6188 | 71318

I want a single output table like:

City | Schools | Companies | Cattle
-----------------------------------------------------
Chieti | 604 | 3025 | 46684
L’Aquila | 498 | 5213 | 89456
Pescara | 387 | 3152 | 47507
Teramo |430 | 6188 | 71318

How can i do that? Thank you for your help

2

Hi,

You can join the two data sources by using a ExtMergeJoin component, you can read more about this here.

  • Join the data based on a key (in your case it would be City)

  • Output the values using the Transform property in the component

3

So easy, thank you very much!