Datatable extraction from base web

[Anil_G (Anil Gorthi)]

@Zishan_Sk

as far as the structure of the table is concerned only the styling component is defining the rows and no seaprate tag

so each value is extracted as separate row in same column

so a little post processing will extract the full data

so after extraction as there are 8 columns…loop on the extracted table and create the required table with 8 columns and send the data

Extract and then process it

Extract
table settings

"<Table xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xsd='http://www.w3.org/2001/XMLSchema' Type='Structured' AddCvHeader='true' IsScrollEnabled='false'>
	<Column xsi:type='DataColumn' ReferenceName='Column0' Name='New column 0'>
		<IsValidName>true</IsValidName>
		<ValidationErrorMessage />
		<IsExtra>false</IsExtra>
		<CanExtractSimilar>false</CanExtractSimilar>
		<Format xsi:type='TextColumnFormat' />
	</Column>
</Table>"

meta data

<extract> <column exact='1' name='Column0' attr='fulltext'> <webctrl tag='div' idx='2' /> <webctrl tag='div' idx='2' /> <webctrl tag='div' idx='1' /> <webctrl tag='div' idx='1' /> <webctrl tag='div' /> <webctrl tag='div' /> <webctrl tag='div' idx='1' /> <webctrl tag='div' idx='1' /> </column> </extract>

for each values
Enumerable.Range(0,Cint(ExtractDataTable.RowCount/8)).ToArray

Add data row
{ExtractDataTable.Rows(currentNumber*8)(0).ToString,ExtractDataTable.Rows((currentNumber*8)+1)(0).ToString,ExtractDataTable.Rows((currentNumber*8)+2)(0).ToString,ExtractDataTable.Rows((currentNumber*8)+3)(0).ToString,ExtractDataTable.Rows((currentNumber*8)+4)(0).ToString,ExtractDataTable.Rows((currentNumber*8)+5)(0).ToString,ExtractDataTable.Rows((currentNumber*8)+6)(0).ToString,ExtractDataTable.Rows((currentNumber*8)+7)(0).ToString}

Flow

output

Hope this helps

cheers