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