In this dummy set, there is only a SINGLE datatable extracted which is diff from mine.
Actual data scrapping in my flow looks like this :
THEN FINAL WRITE TO EXCEL
WHICH BECAME THIS (MOCKUP DATA):
Reason why i uses this why because all these extract structured data info belongs to 1 person after each loop
yellow is Extract Structured Data 1 var = dt1
red is Extract Structured Data 2 = dt1
green is Extract Structured Data 3 = dt1
blue Extract Structured Data 4 = dt1
brown is Extract Structured Data 5 = dt1
so for every Extract Structured Data table it extract is will end up in the next column and next row.
You need to construct your datatable how you want it to appear, you will need to add “blank rows” for each datatable to match that of the largest table for each sub group
So John will have a max row count of 4
Mary will have a max row count of 3
Amy will have a max row count of 2
a quick question, should i name all my datatable the same variable or different? i name it all the same because all are somehow correlated data.
and should my workflow look something like this?
do i need to build a data table?
1-Initially take a counter and assign the value as “1” and take a ‘foreach row’ and put all the scrapped datatables in it .
2-Name all the Datatables with the different names.
3- After the dataScraping of each table Calculate the rows count of each datatable.
4-After this Write the datatables using the count values of rows using write range activities and the increment the counter.