Hello, I’m new to FME, and I was assigned a simple task to convert some json files to csv files so that they could be easily loaded into ODI.
It’s like:
json:
{
"projects": [
{
"name": "Project A",
"tasks": [
{"id": 1, "title": "Design", "status": "Complete"},
{"id": 2, "title": "Development", "status": "In Progress"}
]
},
{
"name": "Project B",
"tasks": [
{"id": 3, "title": "Research", "status": "Pending"}
]
}
]
}
csv:
name, title, status
Project A, Design, Complete
Project A, Development, In Progress
Project B, Research, Pending
I’ve spending 2 days on it and still don’t have a clue how to do it. Thanks in advance for your help.
If it is possible, would you please provide a fmwt? Big thanks again!
