I am currently using Data Point 3.2. I have been asked to create 2 different files, one in an excel spreedsheet, the other in a Pipe delim file. I store both reports in a folder and then use the ftp to move a copy to another server folder.
Is there a way to run the query once and create 2 files and move one without having to re run the same query. I used the export file to create the excel and pipe files ( youo still have to load the query twice. Then I used the ftp to move the pipe file over to another server folder.
I would greatly appreciate any suggestions to reduce the amount of times of the same query.