try to convert list map of multiple to a single record

asked 2019-01-31 10:17:20 -0600

srinath_222 gravatar image

updated 2019-01-31 13:52:44 -0600

iamontheinet gravatar image

Problem statement :

I am trying to convert multiple records with list map into a single record .

ID 1 list map a ID 1 list map b Id 1 list map c


ID 1 list map a , b , c

its basically multiple records with list map into a single record for some time .

Any one whom has done facing similiar issue and had some solution please do post in this it would be a real help .

thanks in advance

Sample input:

image description

Desired output in elastic search:

                "ROWID_OBJECT": "100008",

               "PSI": [
                       "SYSTEM_ID": "417008634"
                    } ,

                        "SYSTEM_ID": "901785927"
                    } ,

                        "SYSTEM_ID": "901787068"

edit retag flag offensive close merge delete


For clarity, do you mind updating your question with sample input record--and preferably a screenshot of it in preview mode? Thanks!

iamontheinet gravatar imageiamontheinet ( 2019-01-31 11:29:46 -0600 )edit

So your origin and destination are both Elasticsearch?

iamontheinet gravatar imageiamontheinet ( 2019-01-31 14:03:10 -0600 )edit

Orgin is SQL Server client through JDBC consumer and destination is Elastic search

srinath_222 gravatar imagesrinath_222 ( 2019-01-31 14:17:45 -0600 )edit