Basic Data Profile tool to profile csv file

[amcgill2]

Hello Alteryx community! I am hoping you can help me with the below questions as I am a super new user to Alteryx! I need to use the basic data profile tool to profile the RTT_SUMMARY All Reduced.csv table and make sure no data is truncated. Can you please help me create these workflows to answer the questions accurately? 

1. Which TWO fields have the most numbers of Null values?
2. Which fields should not have any null values and must be fixed?
3. Auto Field tool has set the data type for each field. Identify the fields that the Auto Field data type is set incorrectly.
4. What is the earliest and latest of DOCUMENT_DATE and RECORDING_DATE?
5. What is the range of TOTAL_CONSIDERATION?

[apathetichell · Accepted solution]

Added a data profiling container to show you much of what you are asking about... two of the most useful alteryx tools to get a handle on are summarize and multi-field formula. Multi-field formula is really the best/only way that many of us will convert existing fields between data types as it's the only way to ensure that data isn't lost and it ends up how we want it.

so when you are creating a new date field (like @atcodedog05  did for your other post - you can use the formula or date/time tools - but for keeping the same field name (or for a slew of fields at once) - multi-field formula is the way to go!

[atcodedog05 · Accepted solution]

Hi @amcgill2 

You can use field summary tool to get brief basic summary of the data. You can output the O anchor output to a csv file.

Hope this helps 🙂