AnsweredAssumed Answered

Creating JSON Profile with data coming from multiple sources

Question asked by RohithKodakandla5291 on Apr 21, 2017
Latest reply on Apr 21, 2017 by mayank.kanodia778203

I have a JSON profile like below.

 

{

    "quoteId": "123456",

    "createDate": "20170421",

    "createdBy":"Test User",

    "agentInfo":{

            "id": "12343",

            "fName": "Luke",

            "lName": "Skywalker",

            "licenseNumber": "3434"

     }

}

Input data for creating this document comes from two different sources in following format.

 

Flat File 1:

quoteId | createDate | createdBy

123456 | 20170421 | Test User

Flat File 2

quoteId | agentId | agentFName | agentLName | agentLicenseNumber

123456 | 12343 | Luke | Skywalker | 3434

 

Is it possible to combine FF1 and FF2 to map in such a way that I end up with the expected JSON output?

Outcomes