Action.ExportQuery
Posted: Fri Jan 21, 2022 4:54 pm
Hello,
I would like to automatically export joined data into a CSV.
I have created a Query which works and can be exported manually into a CSV fine.
I am attempting to use the Action.ExportQuery function to export the data into a CSV automatically.
The query is named Joineddata
However I am getting the following error:
Please could you give me a hint as to where I am going wrong?
Thank you.
I would like to automatically export joined data into a CSV.
I have created a Query which works and can be exported manually into a CSV fine.
I am attempting to use the Action.ExportQuery function to export the data into a CSV automatically.
The query is named Joineddata
Code: Select all
Action.ExportQuery
· "Joineddata"
· "C:\\query.csv"
· true
Code: Select all
01/21/2022 16:47:51
1 | Execution failed with unexpected error:
1 | SQL logic error
1 | no such table: Joineddata
Thank you.