after merging two xml files i have data in a single column - result. I need to write it in an excel file splitting the result every 9 records like 1 2 3 4 5 6 7 8 9 1 2 3 4 5 6 7 8 9 1 2 3 4 5 6 7 8 9 <img src="https://higherlogicdownload.s3.amazonaws.com/HITACHI/MigratedImages/0681J000006PyTYQA0.png" alt="pastedimage_1"> <a data-tag-text="Pentaho" data-sign="#" class="user-content-hashtag" href="https://hitachi.connectedcommunity.org/search?s=tags%3A%22Pentaho%22&executesearch=true" data-tag-key="70b4436b-4549-4ce3-aa64-4566c7b665c9">#Pentaho</a>

Pentaho

View Only

archana garikapati posted 06-08-2019 18:54

after merging two xml files i have data in a single column - result. I need to write it in an excel file splitting the result every 9 records like

1 2 3 4 5 6 7 8 9

pastedimage_1

#Pentaho

Naveen Kumar posted 06-10-2019 04:39

Hi Archana,

There are many ways of doing this. One of them is by assigning sequence to every record, then divide them into set of 9.

Finally, group by with Concatenate aggregation to get the desired result.

I have attached the images for your reference:

Best Regards,

Naveen

archana garikapati posted 06-10-2019 13:29

can I see the options on calculator and group by on how you divided them into 9?

archana garikapati posted 06-10-2019 13:30

can I see the options on calculator and group by on how you divided them into 9?

Naveen Kumar posted 06-11-2019 01:40

calc-division

Regards,

Naveen