Home
Hi all
I am still new in Kapow , i am strugling to retieve data stored in DB. Below is brief description
I created another robot separately for storing data in DB, four rows have been stored in DB, as they are on excel sheet, all values are returned as Output(returned Values) but it writes only one row in the file
Variables: I created Variable(Ex2) of simple excel for setting up the content of the cells(Headers)
When configuring "Write file step" I used Ex2 variable in the file content
SQL Query i used is :"SELECT * FROM TableName". I Want to write all values stored in my DB to the file
Robot structure.
Please advise
Thank you.
I am still new in Kapow , i am strugling to retieve data stored in DB. Below is brief description
I created another robot separately for storing data in DB, four rows have been stored in DB, as they are on excel sheet, all values are returned as Output(returned Values) but it writes only one row in the file
Variables: I created Variable(Ex2) of simple excel for setting up the content of the cells(Headers)
When configuring "Write file step" I used Ex2 variable in the file content
SQL Query i used is :"SELECT * FROM TableName". I Want to write all values stored in my DB to the file
Robot structure.
Please advise
Thank you.
Last edited by Sie on Wed Nov 06, 2019 4:46 pm; edited 1 time in total