Hi All,
I am new to Streamsets, I have sample JSON file, I want to convert JSON file to CSV file, finding difficult to achieve, could you please help anyone here
Input:
{
"Name": "Jane",
"Country": "US",
"children": [
{
"firstName": "Alice",
"age": 6
},
{
"firstName": "Bob",
"age": 8
}
]
}
Expected OutPut:
Name, Age, FatherName, Country
----------------------------
Alice, 6, Jane, US
Bob,6, Jane, US
--
You received this message because you are subscribed to the Google Groups "sdc-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sdc-user+u...@streamsets.com.
To view this discussion on the web visit https://groups.google.com/a/streamsets.com/d/msgid/sdc-user/cda19a88-1c53-4fc3-9e9a-9163d7f23fd4o%40streamsets.com.
Hi Mitch Barnett
I tried with processors, as json have nested structure,unable to get the excepted output
Thanks,
Manas
To unsubscribe from this group and stop receiving emails from it, send an email to sdc-...@streamsets.com.
If the JSON is not ‘flat’, you will need to use Field Flattener
To unsubscribe from this group and stop receiving emails from it, send an email to sdc-user+u...@streamsets.com.
To view this discussion on the web visit https://groups.google.com/a/streamsets.com/d/msgid/sdc-user/c0c28789-4de4-4794-8d15-72e43fa06ecco%40streamsets.com.
Hi Mitch Barnett
I tried with Field Flattener and other processors, I am getting single record only, I need to get 2 records, unable to get the excepted output.
Here I used bit of python code to get the result.
Output:
Is there any similar way to get the expect result in Streamsets, While using processor I am unable to get the expected result
Hi Pat ,
Could you please help here
Thanks,
Manas
To view this discussion on the web visit https://groups.google.com/a/streamsets.com/d/msgid/sdc-user/c0c28789-4de4-4794-8d15-72e43fa06ecco%40streamsets.com.
To unsubscribe from this group and stop receiving emails from it, send an email to sdc-user+u...@streamsets.com.
To view this discussion on the web visit https://groups.google.com/a/streamsets.com/d/msgid/sdc-user/bb833740-90b4-4d6b-a875-a99c47909996o%40streamsets.com.
--
Wow... Thank you so much Marty Norries