Skip to main content
Solved

There is a syntactical error in the SQL statement using Data Table : Write to file Action item

  • 22 December 2022
  • 4 replies
  • 459 views

Scenario:

Open URL - https://www.nseindia.com/market-data/live-equity-market?

Extract the whole table data into Excel (xslx)

Method 1: 

Under Data table package, I have used Write to file “Throws an exception”

Error:

Note:

The Extracted Table header value contains two rows of values. how to change the Data table column header value.

4 replies

Padmakumar
Userlevel 7
Badge +13

Hi @Prabu.B1 ,

 

Could you please confirm your Control Room build?  Else, you can check the Encoding option which have selected. It could be because of that.

Padmakumar
Raul Jaimes
Userlevel 5
Badge +9

Hi @Prabu.B1 

I get the same error if i use ANSI. Try to change the codification to UTF-8. Using  a csv file is a suggestion.

 

This may be due to the following reason: An unknown error occurred while trying to write data table to "C:\RPA\Test\ExtractedData.csv". If the problem persists, please contact your System Administrator.

 

 

 

 

HTH

 

Regards

 

P
Badge +3

Hi @Raul Jaimes 

 

Thank you. Really appreciated.😀

 

Moreover UTF-8 - Second line of header value doesn’t appear. 

I have tried UTF-8 with BOM works fine exactly what extracted from webpage.

 

 

Regards,

Prabu Baskaran.

Prabu Baskaran
Raul Jaimes
Userlevel 5
Badge +9

Hi @Raul Jaimes 

 

Thank you. Really appreciated.😀

 

Moreover UTF-8 - Second line of header value doesn’t appear. 

I have tried UTF-8 with BOM works fine exactly what extracted from webpage.

 

 

Regards,

Prabu Baskaran.

Great!

Reply


Terms & ConditionsCookie settings