I have unstructured data which I’m now structuring using the the generate data activity. I now have a table with one column and every value from the output in a row on there own. I now need to Iterate through generated data table then output selected rows, then add that output to specific excel columns. How can I achieve this? Keeping in mind some rows will need to be merged with others as they were a full sentence in the unstructured data.
Or is there a better way to do this like string splitting? Keeping in mind the original unstructured data changes every day but it’s consistent
Hi
Sorry buddy I don’t get this
If we are trying to insert that generated datatable then we can directly insert to a excel with write range activity
Or are we trying to validate or change any value while iterating and then inserting the value to excel as a whole datatable
If so may I know what we are trying to modify
From the generated table. I now have one table with one column and many rows. I need to filter the rows and merge some row data. Your helping me in another thread actually.
Hmmmm lets say i want to keep rows 1,2,3,4,5,6,7. merege rows 6 & 7? The hard part i am finding is the unstructured data output will change everyday so need my workflow to adapt