How I can use in data scrpping suppose I have data table and that having 8 rows and I only want 5 rows so how I can add the condition for that?

[kaveri_satpute]

Hello ,
please guide for the below issue

thank you in advance

How I can use data scrpping? suppose I have data table(data scrpping data table) and that having 8 rows and I only want 5 rows so how I can add the condition for that?

[ppr (Peter Preuss)]

@kaveri_satpute

I have data table(data scrpping data table) and that having 8 rows and I only want 5 rows so how I can add the condition for that?

you can modifiy the MaxNumberOfResult parameter to 5 (datascrapping)

Or

• Extract all data - output: ExtractData
• slice rows with the help of skip/take

Taking the first 5 rows:
Assign Activity:
dtNew = ExtractData.AsEnumerable().Take(5).CopyToDataTable

taking row 2,3,4,5,6:
Assign Activity:
dtNew = ExtractData.AsEnumerable().Skip(1).Take(5).CopyToDataTable

[HowTo] LINQ - First Start # Skip | Take | SkipWhile | TakeWhile Operator

This HowTo gives an introductory overview of the partition Operators: Skip, Take, SkipWhile, TakeWhile Introduction The partition operators are used to fetch a particular subset from a set of items. The returned subset is formed by the contiguous items that are matching the provided condition. Skip / Take Operator The Skip Operator will omit the subsequent items from the given start for a given length and will return the remaining items The Take Operator will return the subsequent items fr…

[kaveri_satpute]

Can you please briefly explain first solution how I can use that method

[ppr (Peter Preuss)]

@kaveri_satpute

Can you please briefly explain first solution how I can use that method

first:

@ppr

you can modifiy the MaxNumberOfResult parameter to 5 (datascrapping)

like here:

[kaveri_satpute]

Thank you @ppr it is working but i’m working data scrpping in while loop five times and for every couter that row should be six so for total 5 counter rows will be 30
using maxnumberofresults getting only six rows for 5 counter like we added maxnumberofresults

how that all 5 counter data table value will get 30rows

I have attached the screenshot

please guide

[ppr (Peter Preuss)]

@kaveri_satpute

i’m working data scrpping in while loop five times and for every couter that row should be six so for total 5 counter rows will be 30

just adapt or combine with take() method approach

feel free to share some more details on your detail modellings / implementation

[kaveri_satpute]

Take function is not available in uipath I was trying to add

[ppr (Peter Preuss)]

@kaveri_satpute

Take function is not available in UiPath

maybe intellisense is not showing at the first shot, but Take method is available. Share with us the tried details. Thanks

[kaveri_satpute]

Hi I send you the workflow please check

TEstProcess_Mr_lodge.zip (19.4 KB)

[kaveri_satpute]

@ppr have you check the workflow uipath version is 2020.10 still facing the function issue of take()

[ppr (Peter Preuss)]

ExtractData.AsEnumerable().Take(5)