Datatable without using column & row reference

[Smitesh_Aher1 (Smith)]

Hi Team,

I want to extract matching values from the datatable for that i have used ‘extract table data’ activity for fetching the values. But that fetched datatable not have column and rows.

After fetching values i want to extract values present in datatable like (Argument 1, Argument 2, Argument 3)… only want to extract those values which contains ‘Argument’. For this i am using filter data table activity. But not getting output of filter table.

how we can use filter table activity without refrence of column and rows? Please help me to reach out this.

[postwick (Paul Ostwick)]

@Smitesh_Aher1

But that fetched datatable not have column and rows.

Yes it does. A datatable cannot exist without columns. You’re getting data from an app or web page using Extract Table Data? Are you saying the Extract Data Table isn’t getting the data from the app or web page? If it’s not, then you don’t have it configured correctly. If you’re not trying to get table data from an app screen or web page, then Extract Table Data is not what you use.

Show us what you’re doing. Show us the app or web page. Show us your code. We can’t help based on “it doesn’t work.” We need details.

[ppr (Peter Preuss)]

@Smitesh_Aher1

But that fetched datatable not have column and rows

please elaborate more on this. Maybe you can share with us the details from the extract result by using the debugging panels e.g. immediate panel (type in the variable name)

Understanding the 6 Debugging Panels of UiPath in the easiest way possible!

One of the very important topic of UiPath in Debugging is understanding the different debugging panels and when to use which panel during debugging. In this video, we will understand all the 6 debugging panels of UiPath in the easiest way possible. Video Link: Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - YouTube

[Smitesh_Aher1 (Smith)]

Hi @postwick , @ppr ,

@postwick You’re getting data from an app or web page using Extract Table Data?-—> Yes i am getting data by using extract data table activity. Please see below image.

I want only Argument values. so for that i am using filter table activity.

[Smitesh_Aher1 (Smith)]

@postwick i am able to fetched data from web application by using extract table activity but how to fetch values which contains ‘Argument’ from fetched datatable.(for that currently i am using filter data table activity but it’s not giving expected output)

Otherwise can we directly fetched ‘Argument’ values by using extract table activity or by any other activity?

[Shiva_Nikhil]

@Smitesh_Aher1

do you having only one column which you need to check whether it has having argument value or not

cheers

[postwick (Paul Ostwick)]

That is not table data that you’d use Extract Table Data for. This is the kind of thing Extract Table Data is used for:

[postwick (Paul Ostwick)]

It looks like what you should use is Get Text, then Split on VbCrLf to break it into rows in an array, then loop through the array to get the values you want.

[Smitesh_Aher1 (Smith)]

Yes correct… But column name is not present. Please refer image.

Bot should click on values which contains ‘Argument’ serial wise. So, how we can we do this any idea?

[Smitesh_Aher1 (Smith)]

@postwick Can you share me sample flow? for better understanding.

[Shiva_Nikhil]

@Smitesh_Aher1

can you share your sample expected output

so that i can help

[Smitesh_Aher1 (Smith)]

Hi @Shiva_Nikhil

I am not getting expected output. But what i did in code that will tell you,

Step 1:- Used open browser activity

Step 2:- Then i used extract data table activity and succesfully extracted the values from datatable like below.

Step 3:- After that i used output datatable activity and i get below data.

Step 4:- Then i am using Filter data table activity for getting ‘Argument’ values only. But i am not getting expected output.

As per above step i have created flow.

[Shiva_Nikhil]

@Smitesh_Aher1
The output of output datatable activity is string for example stroutput

2.you follow the below
Strfinaloutput=stroutput.split({environment.newline},StringSplitOptions.RemoveEmptyEntries).Where(Function(x) x.Contains(“argument”)).ToArray())

Gives you an array
You can using it by using for each for the array
Strfinaloutput is an array of type string

Cheers

[Smitesh_Aher1 (Smith)]

Hi @Shiva_Nikhil

I am getting below error,

[Shiva_Nikhil]

@Shiva_Nikhil

Strfinaloutput=stroutput.split({environment.newline},StringSplitOptions.RemoveEmptyEntries).Where(Function(x) x.Contains(“argument”)).ToArray())

Strfinaloutput=stroutput.split({environment.newline},StringSplitOptions.RemoveEmptyEntries).Where(Function(x) x.Contains(“argument”)).ToArray

try by removing the brackects at last
cheers

[supriya117 (Supriya Allada)]

Hi @Smitesh_Aher1

Try this:
filteredData = extractedData.Split({Environment.NewLine}, StringSplitOptions.RemoveEmptyEntries).Where(Function(row) row.Contains("Argument")).ToArray()

Hope it helps.

Hope it helps.

[Smitesh_Aher1 (Smith)]

Hi @Shiva_Nikhil

Now error is gone but i am not getting expected output. It is not splitting ‘Arguments’ links.
It gives me output as whole table values.

[supriya117 (Supriya Allada)]

@Smitesh_Aher1

Try this:

filteredData = extractedData.Split(New String() {vbLf, vbCrLf}, StringSplitOptions.RemoveEmptyEntries).
    Where(Function(row) row.Contains("Argument")).ToArray()

[Shiva_Nikhil]

@Smitesh_Aher1

can you share the sample output which you are getting after output datataable activity

[Smitesh_Aher1 (Smith)]

Hi @supriya117

I used the same expression as you given me but still it fetching whole datatable value. Please check below expression is correct?