I have an json file in local disk and I want to write the data to columns.

KulaDeepu_KD

data format:

[
    {
        "ID": "id",
        "INFO": {
            "NAME": "name",
            "COURSE": "course",
            "BRANCH": "branch",
            "SEMESTER": "semester",
            "ON": "on"
        },
        "DATA": {
            "TABLE": {
                "code1": [
                    "subject",
                    "credits",
                    "grade"
                ],
                "code2": [
                    "subject",
                    "credits",
                    "grade"
                ]                       
            },
            "GPA": "gpa",
            "CGPA": "cgpa"
        }
    }
]

needed cloumns are id,name,course,branch,semester,on,code1(subject),code2(subject),gpa,cgpa

colin

Hi @KulaDeepu_KD ,

These two examples, here and here, should help - they show how to map such data to columns.

Cheers,

Colin