Iterate through generated data table then output selected rows, then add that output to specific excel columns

Hi all,

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 @rohangroombridge ,

The unstructured data is in Text file? if yes then convert the text file in to excel file and compare the table which you have with one column .

No its stored in a string variable from a get text activity

Can anyone help here?

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

Cheers @rohangroombridge

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.

Yah that’s fine
What you would like to filter and how you want to merge
Cheers @rohangroombridge

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

Say my data table says this:
Column1
row1[Value1]
row2[Value2]
row3[Value3]
row4[Value4]
row5[Value5]
row6[Value6]
row7[Value7]

1 Like

Great
what would be this change probably
@rohangroombridge

The values in rows 6 and 7 will change daily so i need to have a workflow that i can change with it or pick up different values

Fantastic
here you go
BlankProcess.zip (16.6 KB)

Cheers @rohangroombridge