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:

  • Access almost any source from a single tool
  • Visually drag and drop to create SQL queries
  • Profile, transform and cleanse data easily
  • Automate frequent reporting tasks

Use these links below to learn more about the most popular Toad Data Point topics!


Getting Started



Mastering
Connectivity

Writing
Queries

Import/Export


Automation

Community Discussion

InfoMan
Follow / 26 Apr 2018 at 3:55pm / Toad Data Point

Exporting 8.1MM row Dataset

Expand content
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...

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 4.3.0.718 (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.

Unanswered 1 0 / Create an account to join the discussion.
InfoMan
Follow / 19 Apr 2018 at 9:54pm / Toad Data Point
Latest post by on 19 Apr 2018 at 10:05pm

Calculated Column returns as a string instead of a number value

Expand content
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...

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.

Toad Data Point 4.3.0.718 (32 bit)

Unanswered 251 1 / Create an account to join the discussion.
MR BARKER
Follow / 17 Apr 2018 at 10:59pm / Toad Data Point
Latest post by on 19 Apr 2018 at 6:24pm

How to export SQL script to Qlik Sense QVD

Expand content
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. Thanks

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.

Thanks

Unanswered 305 3 / Create an account to join the discussion.