When I Assign the datarow to select the column of datatable there's cannot find

Assign:Cannot find column [Type]
I use the DataScraping to get the data then I use the Assign, there is my code:
WIList = TransactionData.Select(“Type = ‘WI5’ AND Status = ‘Open’”)
Then I run my files ,when it run to Assign it false
WIList type is DataRow
I try many ways but them false,contains to check the selector but it’s right
I can’t find the wrong
please help me

HI @HuaiYe,

After scrapping the DataTable, could you try viewing it in the immediate panel, just to check whether the Column Type exists?

If it does exist, then create a List of DataRows and Assign →

Dt.AsEnumerable().Where(Function(w) w("Type").ToString.Trim.Equals("WI5") AndAlso w("Status").ToString.Trim.Equals("Open")).ToList()

Kind Regards,
Ashwin A.K

Thanks for your kind answer @ashwin.ashok ,
I try your ways to fix my wrong but there is a new problem
Assign: Column ‘Type’ does not belong to table .
When I after Scrapping the data I saw the column contains the row of “Type”, so I create a List of datarow,there is my code:
List = ExtractDataTable.AsEnumerable().Where(Function(w) w(“Type”).ToString.Trim.Equals(“WI5”) AndAlso w(“Status”).ToString.Trim.Equals(“Open”)).ToList()
If I do something wrong step?
Maybe should I restart my scrapping?
Wish your reply,
HuaiYe

Hi @HuaiYe ,

Would you be so kind as to provide us a snapshot of the DataTable in the Immediate Panel?

This is to verify whether the spelling of the Header is accurate or if they exist.
,
Kind Regards,
Ashwin A.K

HI @ashwin.ashok ,
There is the snapshot of my Immeditate Panel of DataTable and LogMessage.



Wish reply,
HuaiYe

Hi @HuaiYe ,

It seems as though the Data Scrapping was performed unsuccessfully.
Could you try using the Data Scrapping Wizard?

image

The Modern Design Experience has to be disabled for this option to be available.

You can use the Extract Table Data Activity as well if Modern Design Experience is enabled like so:

image

ExtractDataFromWeb.xaml (11.8 KB)

Kind Regards,
Ashwin A.K

1 Like

Thanks for your kindness @ashwin.ashok ,
I restart the scarapping,then I succeed get the column of Type.
Then my Assign can run.
Thanks for your kindness,the ways to me are helpful.
Thanks again,
HuaiYe

1 Like

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