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