let me write the full story again.
so my job is to extract multiple datatable out from a site.
Each datatable rows are varies
This is a dummy set of the exact workflow of what i did.
Main.xaml (70.5 KB)
https://www.easports.com/fifa/ultimate-team/fut/database ( this is the dummy website that i did)
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):
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.
This is what i wanted:
Technically u can ignore the workflow that i give because the main concerned is the multiple Extract Structured Data table and the format in excel.