how to extract nested loop for json file

[poorna4167]

Hi,

I am new into talend .Can you help me to extract the data from talend from below data.Need step by step procedure.

{

    "CorporateData": {

        "Rohan": {

            "Year 2024": {

                "Company": "Abcd",

                "Duration": "12 months",

                "projects Done": "2",

                "Salary": "5LPA",

                "Joining_Date":"2022-03-21 14:00"

            },

            "Year 2025": {

                "Company": "Abcd",

                "Duration": "12 months",

                "projects Done": "1",

                "Salary": "7LPA",

"Joining_Date":"2021-05-26 09:00"

            },

            "Year 2026": {

                "Company": "Abcd",

                "Duration": "12 months",

                "projects Done": "1",

                "Salary": "8LPA",

"Joining_Date":"2021-11-21 14:00"

            }

        },

        "Ankur": {

            "Year 2024": {

                "Company": "EBD",

                "Duration": "12 months",

                "projects Done": "2",

                "Salary": "8LPA",

"Joining_Date":"2020-11-21 16:00"

            },

            "Year 2025": {

                "Company": "EBD",

                "Duration": "12 months",

                "projects Done": "1",

                "Salary": "8LPA",

"Joining_Date":"2024-07-21 09:00"

            },

            "Year 2026": {

                "Company": "EBD",

                "Duration": "12 months",

                "projects Done": "2",

                "Salary": "10LPA",

"Joining_Date":"2021-11-21 19:00"

            }

        }

    },

    "meta": {

        "consensus": "median",

        "updated": "2024-07-11"

    }

}

[Or]

Try the approach at the bottom of this one:

https://www.linkedin.com/pulse/omg-i-can-read-json-qlik-sense-christof-schwarz

[poorna4167]

Can you help me to steps to extract the json above json file .The above video is not helpful for me.

regards,

Chandu

[Dave_Simo]

Hello ,

You can use this handy link https://jsonpathfinder.com/ to see which query to put in your tExtractJSONFields

Best Regards,