AnsweredAssumed Answered

Filter to save Result Set in an Excel Sheet saves a corrupt excel file and when saved as .txt file; it saves in different format

Question asked by preetioc on Mar 8, 2019
Latest reply on Mar 11, 2019 by jnesmith

Filter to save Result Set in an Excel Sheet saves a corrupt excel file and when saved as .txt file; it saves in different format-

 

I am using "SQL Database execution" step for my test case and then a "Do-nothing" step. At "Do-Nothing" step; i have added a filter to "Save resultset to an excel file."

I used "Test & Run" option it shows connection successful and 10 rows were read.

But after I run ITR; it saves an excel file which is coorrupt and I cannot open it.

I also tried to save it as .txt file. But it saved the SQL DB rows & columns as a diffrent format- something like this- "_(* #,##0_0##[] [] []

 

Can someone help me get the correct SQL columns and data stored in excel as a resultset please

Outcomes