Combine two or more tables

loris89

• May 17, 2016 00:00

• Answered

Follow

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

• 

  Pedro Vazquez Rosario

  • May 17, 2016 14:08

  0

  Comment actions Permalink

  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
• 

  loris89

  • May 18, 2016 06:56

  0

  Comment actions Permalink

  So easy, thank you very much!

Please sign in to leave a comment.