Table of Contents
FAQs
What is DQ for Excel™?
DQ For Excel™ is a Microsoft Add-in that works right inside Microsoft Excel, it’s familiar and simple to use! Import data from almost any source, prepare it, master it and perfect it; then upload it back to almost any target. Process hundreds of thousands of records at once and only pay for your usage on a credit based model.
DQ For Excel™ is powered by DQ on Demand™, DQ Global's Data Quality as a Service (DQaaS) Data Quality Improvement Platform.
What is DQ on Demand™?
DQ on Demand™ is a Data Quality as a Service (DQaaS) Data Quality Improvement Platform. DQ on Demand™ delivers a suite of data quality improvement utilities, designed to make the task of enterprise data management simpler.
How long does it take to set up DQ for Excel™?
DQ for Excel™ can be installed in minutes from the Microsoft Office store.
Where can I install DQ for Excel™?
DQ for Excel™ can be found in the Microsoft Office store which you can access via heading to the Insert tab within Microsoft Excel and selecting 'Get Add-ins'.
A full Installation Guide can be found here.
How much does DQ for Excel™ cost?
Billing for DQ for Excel™ is transactional, i.e. each request will consume credits, which can be spent on any of the available services. The application can be installed free of charge from the Microsoft Store.
How do I buy credits?
Credits can be purchased at the DQ Global Shop which can be found at https://shop.dqglobal.com/.
Will I be charged if my operation isn't successful?
If the operation was not processed by DQ on Excel™ then no charge will apply.
Are records grouped for processing?
Records are processed in batches of 1000 for all first party functions.
After I try running a function, the application tells me "This API Key does not have access to this function." How can I resolve this?
This is most likely due to permissions not being granted to the API key. Head to https://shop.dqglobal.com/my-account/ and Login. From there, head to the Permissions section on the left-hand menu. From here, you will be able to add permissions to use first-party and third-party functions. If the problem still persists, please contact the DQ Global Support team (support@dqglobal.com).
I seem to be having display errors throughout the application. How can I resolve this?
If your PC is running at a display scale other than 100%, run MS Excel in Compatibility Mode to avoid display errors.
Who can I contact for support using the application?
If you have any questions, please contact us at support@dqglobal.com and we will get back to you as soon as possible.
What are data types?
A data type, in programming, is a classification that specifies which type of value a variable has and what type of mathematical, relational or logical operations can be applied to it without causing an error.
Examples of different data types you might be using with DQ for Excel™ include:
string - A sequence of characters and the most commonly used data type to store text. Additionally, a string can also include digits and symbols, however, it is always treated as text
string[][] - A table of strings, it's used to represent multiple values returned by a spilling function
boolean - This represents the values true and false. When working with the boolean data type, keep in mind that sometimes a boolean value is also represented as 0 (for false) and 1 (for true)
number - Often used as a data type that includes both of the following types:
- Integer - The most common numeric data type used to store numbers without a fractional component (e.g. 5, 0, -5)
- Float - Also a numeric data type used to store numbers that may have a fractional component like monetary values do (e.g. 5.1, 50.01)