[Solved]Write SQL query result in a text file

Hello guys,

I need some help to write a file with my variables.

I'm running a query database, returning the values and i need to write the query result in a text file.

But the Step "Query Database" brings me a line for each run, is there any way to run the query and get the result as a single file?

Second point, i created a step "Write File" but this step in not helping me because it only write a variable per time. If i could stract the Query result as a single variable and not each collumn\line per time it would help a lot.

I am experiencing the same issue

I'm using the step "Write File", but i only can write one variable.

At the window "File Content" i choose the option "Expression" and added one of my variables.
Marked the box "Append to File" and all the lines were written.

My problem is that i can't write 2 or more variables.

I've tried the following expressions:
"variable1" + "variable2" + "variable3" 
variable1 ++ variable2 ++ variable3
"variable1;variable2;variable3"

But i got no success

Solved.

the right expression is: variable1 + " " + variable2 + " " variable3

Hi i am still new in Kapow,please advise which varialbes are you reffering to?

Are you talking about my input/out put variables. If possible could you please explain using example.

I created a "Type" containing all my database collumns, in the robot i created a variable named "return" and there i've set the "Type".
After the step "Query Database" you need to put a return step, in this step you set return to the variable "Return", after this you put a step "Write File" and at the File Content you input your variables or waht you need to write.

Hi I dd that but still experiencing the same issue, below please see the flow of my robot and the explanations

Robot:


Explanations:
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

Thanks in advance.