I need to split array into row for each item

Help Studio
, ,
1

i need to convert sheet1 to be like sheet2 any help for that please?

ask
ask1149Ă—378 25.9 KB

2

@rpa13 ,

You can check the attached workflow, that will split the rows with the | symbol and add it to a new datatable as new rows. Then you can write that datatable into a new excel as per your need.
Split_DataRows.xaml (9.6 KB)

3

For Each Row in Data Table: Collection was modified; enumeration operation might not execute.
i got this error
askkk

4

@rpa13,

Check the updated workflow.
Split_DataRows.xaml (15.3 KB)

1 Like
5

Main.xaml (10.1 KB)
Please check this…It’s working and easy to understand.Also, Please mark as solution if its working for you !!! Thank you !!

1 Like
6

thanks it work, but if i need to retun it back to be like this
154 10100856 500009893|500010000 1 | 2 1530|1526

8

You can GroupBy “Order_Num” and “Increment” columns

1 Like
9

okay i will try thank you very much dear

10

thank you very much

11

Please mark it as solution so that others can benefit if they face same issue in future.

1 Like
12

can i make condition insert first row and go to next row if the value in incremental_id reapeted insert the row if incremental_id change make action like (save)and go to next colom and so on any help please?

13

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.