So my idea starts with getting the body as string and convert it into an array. After that I tried to clone a data table of that parameter sheet with the items in the array:
The problem is now that the items from my array are only inserted into the first column and not across all 3 columns.
My final idea was to convert the data table into an dictionary and use it similar to a config file where I say parameterSheet(“Period”).toString an get the value next to it.
How can I convert an array to a data table where the items are inserted across all three columns?
The array contains every element from the parameter sheet which is more than 3. Somehow empty entries are still in the array even though I used following code:
So all in all 68 elements (I’m using the original parameter sheet which contains more than the example above)
Hey I am working on a different solution but this is also not working:
So Im creating a new datarow and passing the values of the array to the correct column.
But as soon as the variable “data_row” (type is datarow) has been added to the datable I cant use the same variable again. The error message is that this row already belongs to this table.
Is it somehow possible to give the variable data_row a dynamic name?
Fine
you were almost done
just a small correction
–use a assign activity bodayArray = mailBody.Split(Environment.Newline.ToArray())
–then build datatable activity
–use a for each activity and pass the bodyArray and change the type argumet as string
–now use a add data row and mention the array row as split(item," ") and in the datatable mention the datatable name
–then we can write this datatable to excel with write range