Master detail data to flat File

Questions
,
1

Hi, after some processes i was able to get my data, as the following:
[
{
“array”: [
{
“name”: “ACSRE1DA000025”,
“description”: “DISPO”,
“id”: “40587620-decb-11ed-8340-e978ed212147”,
“data”: {
“Interventi”: [
{
“ts”: 1715348503445,
“value”: “56.0”
},
{
“ts”: 1715348499003,
“value”: “56.0”
},

                ],
                
            }
        }
    ],
    "__IMTAGGLENGTH__": 1
}

]

how can transform into a flat file like the following (trasposing data):

name, description, interventi_ts, Interventi_value
ACSRE1DA000025,DISPO,1715348503445,56.0
ACSRE1DA000025,DISPO,1715348499003,56.0

regards
Gianluca

1 Like
2

Hi @Gianluca_Izzo

To solve your issue, use an Iterator module.

Map the array in the Iterator module and select the Text Aggregator module. Enable the advanced settings and select Separator as “New Row”.

Hope this will solve your issue.

Regards,
Msquare Automation - Gold Partner of Make

Book a Free Consultation | Connect Live

Explore our YouTube Channel for valuable insights and updates!