Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Merge Data into one column

  1. #1
    Join Date
    Jan 2018
    Posts
    1

    Default Merge Data into one column

    can i merge two database column value in one database like if i have column name mobile no. in db1 and column name mobile no. in db2 then can we merge both db1 and db2 and values for columns will be merged in single column mobile no.

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    You have two streams containing tuples (id, mobile) and want to aggregate the mobile field?
    Just unite the streams, sort them on the id, and follow up with aggregation.

    Name:  230822.PNG
Views: 48
Size:  4.1 KB

    Also, no need to hijack threads.
    Last edited by marabu; 01-31-2018 at 03:18 AM.
    So long, and thanks for all the fish.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.