I receive an email which contains a parameter sheet like below and I have to process the values in the second column (“Value”)
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?