After upgrade, column '' does not belong to table DataTable

Hi All,
I’m new to UiPath Studio and I’m using UiPath community stdio recently. I create a new process which using chrome to connect and download exchange rate table from 2 web site and save them to 2 worksheets in a excel file. The UiPath Studio automatically upgrade to 2021.10.4 and it worked fine last week. However,
I found it cannot download table from one of two web site now.

https://portal.sw.nat.gov.tw/APGQO/GC331 (ok)
臺灣銀行牌告匯率 ( error )

I try to do data scraping again, but it show me error below:
error: column ‘’ does not belong to table DataTable

I try several times but still the same error. Does anyone know how to resolve it? or I have to wait for next upgrade?

Thanks a lot!
Golden

Hi @golden_huang ,

Check for any Dynamic Attributes that are Changed and can not find the Exact data you want to extract. Check the website URL of them also.

Thanks,
Srihari

Hello @golden_huang
I guess there is issue with website or the way UiPath interact with it.
Can’t you just download the CSV file of table (Option is there on website) and use it for further processing ?

image

Hi @golden_huang

Mostly this error came while we write data into excel so can you share your flow

Hi Kodi_Shrihari,
Thanks your kindly reply. I don’t have any dynamic attribute. My test is very simple, My step is:

  1. open bank web page
  2. create a open browser activity
  3. click Data Scraping icon in tools
  4. click one item of table in 1. web page, then uipath show error

Hi AkshaySandhu,
Thanks for your reply. If I cannot find the reason why data scarping cannot work for this web page. I will take this way to get the rate data ( I’m just wonder what’s the reason of this issue and how to solve. If I meet the same issue in other web page someday, I know how to resolve it )

Hi Robinnavinraj_S,
Thanks for your reply. My process is very simple and the step is:

  1. open bank web page

  2. create a open browser activity

  3. click Data Scraping icon in tools

  4. click one item of table in 1. web page, then uipath show error

    The data is not extract yet and not data can be write into excel. ( my plan is: step1: extract rate data from web page, step2: write rate data into excel, but the step1 fail, so step2 pending… )

Does anyone have the same problem as me? please share your solution to me. Thanks a lot!

Hi @golden_huang

actually I also tried that website you have provided above , data scrapping is not supported for that website then you can go with screen scraping method


Thanks,
Robin S

I believe this something related to column setting of webpage (I am not sure though).
I was able to extract the data.
Steps:

  1. Extract Wizard
  2. Click on Next
  3. Select data cell from first column
  4. On next pop up click “No” for when asked “Extract the data from whole table?”
  5. Click Next
  6. Select second data cell
  7. Click Next
  8. Click Extract Correlated data
  9. Repeat steps 1-7 for 2nd column and so forth

This will give you all the data but it will be missing headers.

Hi Robin,
Thanks for your kindly reply. You mean the cause of this problem is web site, right? ( I though the cause is UiPath community upgrade ).

Otherwise, I'm using 13" Notebook, I cannot extract full rate records by screen scraping activity.

Golden

Hi AkshaySandhu,
My did the same step as yours. But the error happen after I did step 3. The process does not modify since last week, so, I don’t know the reason. Do you have any idea the possible setting of column? Where and how to check it?

Thanks.
Golden

Try this in Extract MetaData

image

<extract>
	<column exact='1' name='Column1' attr='text'>
		<webctrl tag='tr' />
		<webctrl tag='td' idx='1' />
		<webctrl tag='div' idx='1' />
		<webctrl tag='div' idx='3' />
	</column>
	<column exact='1' name='Column2' attr='text'>
		<webctrl tag='tr' />
		<webctrl tag='td' idx='2' />
	</column>
		<column exact='1' name='Column3' attr='text'>
		<webctrl tag='tr' />
		<webctrl tag='td' idx='3' />
	</column>

	<column exact='1' name='Column4' attr='text'>
		<webctrl tag='tr' />
		<webctrl tag='td' idx='4' />
	</column>
	<column exact='1' name='Column5' attr='text'>
		<webctrl tag='tr' />
		<webctrl tag='td' idx='5' />
	</column>
	<column exact='1' name='Column6' attr='text'>
		<webctrl tag='tr' />
		<webctrl tag='td' idx='6' />
	</column>
	<column exact='1' name='Column7' attr='text'>
		<webctrl tag='tr' />
		<webctrl tag='td' idx='6' />
	</column>
</extract>

Hi AkshaySandhu,
Thank you for reply quickly. I’d try your manner as following:

  1. create a sequence activity inside open browser activity
  2. create a attach browser activity inside attach browser activity
  3. create a extract structured data inside the attach browser
  4. copy and paste the script you mention in ExtractMetaData field, but there is a compile error happen: Option strict On not allow imply transfer from System.Xml.Linq.XElement to string

might be some junk data.
try this xaml
Test.xaml (7.6 KB)

I’d run your Test.xaml, there is not error happen. But no any data was extracted.

Thanks.
Golden

Working fine for me
Check variable pane. Lookout for multiple variable with same name.

Hi AkshaySandhu,
There is no other variable in this process ( I didn’t create other variable manually in this process ).

It looks like the cause of thie problem is still unknow.
So, I will take your advice before and click download .csv button instead of using Data scraping.
I hope I won’t meet this problem in other web page in the future ( I’m not sure whether it will offer a download .csv button ).
Thank you again for your kindly helping.

Golden

1 Like