am trying to extarct table from website contain 15000 record but write rang does not accept it how to solve this issue maybe with for each or make the data base in small batchs and then Append Range Range but how i can do this ? can some one help ?
what in detail is failing?
Hi @Abdalla ,
Could you check by Debugging the workflow, if the Extracted Datatable does indeed contain the 15000 records in it ?
If not, the issue might be in the Extract Datatable/Table Extraction methods.
the workflow is the same for other sequance and work fine only the last table which contain ca 15000 records does not work . my sequance is Extract Structured data then Excel appalication scope and inside it write range
the workflow is the same for other sequance and work fine only the last table which contain ca 15000 records does not work . my sequance is Extract Structured data then Excel appalication scope and inside it write range
there is no error only the data not being written in the target excel tab the tab name is changed as requested but sheet is empty
as mentioned by @supermanPunch debug and trace the flow to get more insights
this is not help at all
we would:
- set a breakpoint and debug
- get paused by the breakpoint
- use immediate panel and check the datatable e.g.
YourDatatable.Rows.Count and check if the datatable is populated or not
So in a first round we can more locate the issue.
@Abdalla
put toggle break point on kill process.
Then go in immediate pane and enter this
ExtractDataTable4.Rows.Count
and check your datatable contains record or not.
If Record is present then use Workbook Write range activity to save the data.
@Abdalla ,
Could you also maybe provide us with the Screenshot of this implementation.
We may be able to optimise the flow in this part. Maybe use Merge Datatables and perform the Appending after all the data from tables have been merged.
Am extract the same table three times but with different parameters once JOb name FM then the record 1211 and it works fine but if the parameter different the records increated and be more than 15000 record and the rows counts show 0
Am extract the same table three times but with different parameters once JOb name FM then the record 1211 and it works fine but if the parameter different the records increated and be more than 15000 record and the rows counts show 0
Perfect as you see working with the immediate panel helps us for the analysis
Next steps you can do:
- isolate and check the cases where not data is ectracted
- also include a selector analysis if data should be extracted but is not
@Abdalla you need to check and verify Table Extraction selector for FA parameter because its not extracting anything. By highlighting check selector highlight correctly or not
Have you tried just writing the DT to a CSV file and seeing if anything is actually being extracted?
selector highlight correctly
@Abdalla select strict selector in targeting option and try this
ashokkarale
mkankatala
ruchirmahajan
Lalit_Chaudhari
Matias_Clemente.Arg
David_Hernandez2
adi.mehare
supermanPunch
AkshaySandhu
edevries