Customize Table Extract as per our requirement

[Anonymouss (Akhil Pandey)]

Hello,

I need to extract the required data from Table Extract

Problem: Using Table extract I get 10 profile links from LinkedIn
but as per my requirement, I need only 8 from 10, and another time when the loop runs, I need to extract 5 out of 10.

I have a total of 10 Links which I have extracted from Table Extract but I need only 8 on which perform actions. if i change 8 to 6 at that time table get only 6 link for me
How can i do this thing?

Thank you!

[Anonymouss (Akhil Pandey)]

Hi,

Need urgent help,

@ashokkarale @AJ_Ask @Gautham_Pattabiraman @sanjay3 @balupad14 @lrtetala @RAKESH_KUMAR_BEHERA

Regards
Akhil

[lrtetala (Lakshman Reddy)]

Hi @Anonymouss

Try this

@Anonymouss

I need only 8 from 10

YourDataTable.AsEnumerable().Take(8).CopyToDataTable()

@Anonymouss

I need to extract 5 out of 10

YourDataTable.AsEnumerable().Take(5).CopyToDataTable()

@Anonymouss

if i change 8 to 6 at that time table get only 6 link for me

YourDataTable.AsEnumerable().Take(6).CopyToDataTable()

Cheers!!

[Gautham_Pattabiraman]

Hi @Anonymouss ,

Is there any criteria you need to use for picking 8/10
Or the first 8 from 10 would do.?

[ashokkarale]

@Anonymouss,

For this you can keep the Max Row property dynamic.

Here is sample solution code.
ConditionalDataExtraction.xaml (15.6 KB)

Output:

Thanks,
Ashok

[Gautham_Pattabiraman]

Hi @Anonymouss ,

Step 1 : using assign, assign the number of rows you want to select to a int32 variable.

Step 2 : use the below statement to select the required number of rows.( assume n as your int32 variable.)

YourDataTableVar.AsEnumerable().Take(n).CopyToDataTable()

Hope this helps you out.!!

Please let me know if you need any condition with you want to pick the records will give you an alternative method.

Thanks,
Gautham.

[Anonymouss (Akhil Pandey)]

Appreciable,

@lrtetala @ashokkarale @Gautham_Pattabiraman
if we need 2 candidates instead of 8 at that time I have to change my code, in the UiPath

I want like this, If I enter 2 instead of 8 in my ExcelSheet at that time my loop runs only 2 times and extract only 2 profile from LinkedIn via Table Extract

Might be my problem is understandable

[Anonymouss (Akhil Pandey)]

10 is also not any criteria, if in the ExcelSheet candidate number is written as 5 at that time table extracts only 5 and fetch data of all 5 five candidate

if we change in excel file → candidate number 5 to 1 at that time it run only once

[Gautham_Pattabiraman]

Hi @Anonymouss ,

Customize Table Extract as per our requirement

Hi @Anonymouss , Step 1 : using assign, assign the number of rows you want to select to a int32 variable. Step 2 : use the below statement to select the required number of rows.( assume n as your int32 variable.) YourDataTableVar.AsEnumerable().Take(n).CopyToDataTable() Hope this helps you out.!! Please let me know if you need any condition with you want to pick the records will give you an alternative method. Thanks, Gautham.

That is Why I suggested you assign the number of records you want to in an Int32 variable and use that inside take() method or you can assign the variable to the max row property as @ashokkarale suggested.

Thanks,
Gautham.

[Gautham_Pattabiraman]

Use a Read Cell, Assign the value to an Int32 variable and pass it on in either of the methods.

It should work fine.

[Anonymouss (Akhil Pandey)]

will you make sequence of this for my better understanding.

Thank you.

[ashokkarale]

@Anonymouss,

It’s easy to add this logic also to my earlier logic.

Input:

Solution:

Sample Code:
ConditionalDataExtraction.xaml (15.6 KB)

Output:

Thanks,
Ashok

[Anonymouss (Akhil Pandey)]

This solution is working.

@ashokkarale @Gautham_Pattabiraman

Thank you
Akhil

[Gautham_Pattabiraman]

@Anonymouss ,

ForumQuestion.zip (10.1 KB)

Sample sequence using another method.

Please mark the response which helped you out as solution so that the thread gets closed.

Happy Automating…!!

Thanks,
Gautham.