Solved

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

  • 22 December 2022
  • 4 replies
  • 75 views

Badge +1

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.

icon

Best answer by Raul Jaimes 22 December 2022, 23:26

View original

4 replies

Userlevel 7
Badge +11

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.

Userlevel 4
Badge +7

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

 

Badge +1

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.

Userlevel 4
Badge +7

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