This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
on 02-15-201710:51 AM - edited on 05-21-201901:01 PM by SydneyF
The Data Profiling in the Browse Tool was created to assist the user in better understanding the quality of their data at any point within the workflow.
This option will assist users in understanding the quality of their data, assist in troubleshooting and help fix issues that may arise when attempting to parse, join, or output their data.
How Data Profiling works:
Add a Browse Tool after any tool you want to check the quality of your data. We highly recommend getting into the habit of adding a Browse Tool after your Inputs. This will allow you to understand right off the bat what your data’s condition is in.
You can then run the workflow and select the Browse Tool. The Configuration Window will display graphs relating to each of your columns in your data as well as some specific information on the field and the type of data. By selecting a specific column in your Results window the Data Profiling in the Configuration Window will change showing you the quality of the data within that column. You will receive different graphs and information depending on the data type in the field.
Please see our wonderful online Help document for the Browse Tool which contains all of the information on the charts and Metadata, click on View data on the page to find out more. We also have a short video that will walk you through the Data Profiling.
Tips and Tricks:
The Browse Tool will only render the Data Profiling when the Browse Tool is selected. Depending on how much data you are running into the Browse Tool, it may take a little time for the Browse Tool to render the Data Profiling reports. If you don’t select the Browse Tool when you are working in the workflow it will not use any memory until you select the Browse Tool to render the reports.
If you would like to capture this data and use the data in a workflow or extract that information you can use the Basic Data Profile Tool. This tool will grab the information from the Data Profiling in the Browse Tool. At this point in time, we do not have the option to export the graphs.
You can turn the Data Profiling feature off by going to your user settings and uncheck the "Collect and display data profile information". However, as recommended earlier in the article, using the Data Profiling after your Input Data Tool is now considered best practice and at the very least the Data Profiling should be used at this point. You can always turn the option off after you have reviewed your data.