@Shu, i am still not able to use the template now getting the error (screen shot attached). but here is a test json..basically all the arrays can repeat multiple times..how to flatten those..?? {
"Customer_Id": 11111,
"dsc": [
{
"Brand_Nm": "test",
"qa": [
{
"Assignment_Id": 222,
"addr": [
{
"AddressLine_1": "stl",
"City": "stl"
}
]
},{
"Assignment_Id": 223,
"addr": [
{
"AddressLine_1": "stc",
"City": "stc"
}
]
}
]
}, {
"Brand_Nm": "test2",
"qa": [
{
"Assignment_Id": 333,
"addr": [
{
"AddressLine_1": "ofl",
"City": "ofl"
}
]
},{
"Assignment_Id": 334,
"addr": [
{
"AddressLine_1": "estl",
"City": "estl"
}, {
"AddressLine_1": "estl1",
"City": "estl1"
}
]
}
]
}
]
} i like it break it as 3 files like Customer_Id,Brand_Nm 11111,test 11111,test2 Customer_Id,qa_Assignment_Id 11111,222 11111,223 11111,333 11111,334 Customer_Id,Assignment_Id,AddressLine_1,City 11111,222,stc,stc 11111,223,ofl,ofl 11111,333,estl,estl 11111,334,estl,estl 11111,334,estl1,estl1 and also is it possible to flatten the entire structure.. Customer_Id,Brand_Nm,assignment_id,addressline_1,city
1 1111,test,222,stl,sttl 11111,test,223,stc,stc 11111,test2,333,ofl,ofl 11111,test2,334,estl,estl 11111,test2,334,estl1,estl1
... View more
