Datatable without using column & row reference

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.

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.

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)

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.


@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?


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


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:

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.

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?

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


can you share your sample expected output

so that i can help

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.

The output of output datatable activity is string for example stroutput 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


Hi @Shiva_Nikhil

I am getting below error,

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

try by removing the brackects at last

1 Like

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.

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.


Try this:

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


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

Hi @supriya117

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