How can get the Column values using Data Scrape Web page DT Column without idx tag

Help Activities
, ,
1

I Extract the Webpage Data Table Column by using Data Scrape

image
image878×600 25 KB

Its Extracting perfect

But In some Case in the future include the extract one column in the DT

That the time its gave a error so that without using idx tag we can get the “Station” Column Values

Is that any ways for geting the Column Values without the idx tag?

2

HI @Rajiduraikannu_Santhosh_G ,

You can extract the whole datatable every time you want post retrieving you can only take the column in the same DT which is required.

Example - DT1 is your extracted DT then in a assign you can write something like
DT1 = dT1.DefaultView.ToTable(False, “Column Name”) this will give you only the required column in DT1.

Thanks,
Shikhar

3

Hi @Shikhar_Tandon ,

Thnk u so much for ur quick rply

I Try this method Its working perfect :star_struck: :+1:t4:

And I have a another error in the wrkflow

In the Wrkflw I checking the Filter are wrk correctly
So that, In the verify activity DT=ExpectDT
{ExpectdDt using the where method Get the Station values and filter the DT and check the Values are correct}

Before I Scrape only the “Station” column its Crtly wrking

image
image913×542 20.3 KB

This is the ExpectDT It gave the Filter value But its shows the whole Table

image
image1493×325 19 KB

So Its gave a false

Can u plz gave suggestion for this also I just wnt the Station Column Values in the ExpectdDT Datatable

Is it possible?

4

Hi @Rajiduraikannu_Santhosh_G ,

Can you explain the other issue again a bit clearly I am not getting the exact problem.

Thanks

5

Hi @Shikhar_Tandon ,

In the Assign activity ExpctdDT I filter the DT using the StrRangeList Values

Its filter the DataTable But its show the whole DT

I want only the Station in ExpectdDT because of that only I verify the DT=ExpectdDT

6

You can use filterdatatable activity instead of the Query.

Thanks

7

ExpctdDT Filter wrks crt

I Extract the Whole DT So that its Filter and Shown the All column

But i want only the Station Column

I that any possible?

8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.