This workflow demonstrates how Alteryx can be used to report metrics on a data file. The goal is to determine how complete the file is. We will identify the valid values per column, and the percent complete each column is.
A warning will be issued for each field that is not 100% complete.
..\SampleData\ParsedData.csv
28591
,
False
254
False
True
True
1
ParsedData.csv
"Type"
True
True
True
False
False
False
False
False
False
upper
C:\Users\John\Documents\Alteryx\Community\Split Rows to Sheets.xlsx|||Sheet1
False
Create
FileName
Type
Split Rows to Sheets.xlsx
Table=Sheet1
Horizontal
Split Rows to Sheets