This is how easy it is:
Warning: Undefined array key 1 in /home/customer/www/dqforexcel.dqglobal.com/public_html/wp-content/themes/Eldo/template-parts/flexible/calltoaction.php on line 63
Our Generate feature empowers users to create a pattern representation of their data effortlessly. Tailor the generated pattern with sets of rules available in the task pane, allowing customisation such as excluding specific characters.
Generate allows you to generate letter, number, symbol, white space and non-printing settings.
The generated patterns provide a quick and intuitive way to review and identify issues within the dataset.
E.g. you have a list of counties and want to see if the data follows a consistent format.
The Token feature in DQ for Excel generates phonetic representations in line with selected algorithms, including Soundex, Metaphone, and DQFonetix.
E.g. below is a comparison of token outputs for various name variations.
This use case showcases the effectiveness of the Token feature in creating phonetic tokens, allowing for precise matching and comparison of names despite spelling or pronunciation variations. DQFonetix, with its advanced capabilities, stands out in providing the best representations for improved data accuracy.
DQFonetix contains our advanced phonetic algorithms developed over the last 25 years by DQ Global. The algorithm is property DQ Global and hence we do not share the specification of the process. However, DQFonetix has four key features:
By generating comprehensive phonetic tokens using DQ for Excel, the feature enhances data interpretability and efficiency. This ensures a clearer understanding of the data, aiding in more effective decision-making.
The generated patterns offer a quick and intuitive way to review datasets, making it easy to identify and address issues promptly. This is especially valuable when ensuring consistent formatting, as demonstrated in the example of counties.
The Token feature in DQ for Excel, especially DQFonetix, allows for the generation of phonetic representations. This feature ensures precise matching and comparison of names, even in cases of spelling or pronunciation variations.
The inclusion of vowels, consonants, punctuation, numbers, and capital letters in the generated patterns provides a precise method for reviewing and understanding data. This level of detail aids in maintaining data accuracy and integrity.
This is how easy it is: