Download the FREE Toad Data Point Viewer
Toad Intelligence Central on Quest.com
Toad Intelligence Central Community on ToadWorld
Product Information on Quest.com
Toad Data Point Release Notes and Product Guides
Toad Data Point v4.3 is now available
Get more from Toad Data Point... with onsite training
Toad™ Data Point is a multi-platform data preparation tool that’s built for anyone who needs to access data from multiple sources, quickly integrate and prepare data to produce datasets and reports for analysis. It dramatically simplifies data access, writing SQL queries and data preparation – all from a single tool and without needing to be a SQL expert. With Toad, you can:
Use these links below to learn more about the most popular Toad Data Point topics!
I'm having trouble exporting an 8.1 million row dataset. Tried going to Excel, it says that it is successful, but the resulting file is 4 KB...so that's no good. Tried going to tab delimited, but it errors right-away and stops.
Toad Data Point 18.104.22.1688 (32 bit)
Log from tab delimited attempt...
Saved the query with results, closed Toad and restarted...same result.
Now trying sending to Local Storage and exporting from there...maybe that will work.
I thought that his was fixed in an earlier version of TDP, but this gremlin has struck me again. I have created a calculated column that is a very simple formula for Gross Margin Dollars ( table1.Revenue - table1.COGS ). I ran this query several times throughout the day, and now it has decided that the result will be string value instead of a numerical value. This means that when I send the results to a Pivot Grid, the column will NOT behave as expected with an aggregation...no summing, averaging, etc....just a zero. How can this be fixed?
Here is a screen shot showing how the values are left aligned (as one would expect for text/strings), instead of right-aligned.
I've written my SQL query and want to export it to a QVD file so that I can load it directly into Qlik Sense, is this possible? I only see options to export to Excel or csv.