Cleaning an Excel File with Requirements

amcgill2

Hello Alteryx Community! I am a super new user and was hoping you would be able to help me create a custom workflow to answer the following questions: 

1. Remove duplicate records.
2. Remove fields ASSESSED_VALUE and COMMON_LEVEL_RATIO (too many Nulls).
3. Remove fields STREET_ADDRESS, ZIP_CODE, and WARD (more accurate data in Property table).
4. Remove transactions without OPA_ACCOUNT_NUM.
5. Convert DOCUMENT_DATE and RECORDING_DATE into date data type.
6. Add a field “date_error_flag”, with a value 1 when DOCUMENT_DATE is after RECORDING_DATE, 0 otherwise.
7. Rename and organize the field names to the following:

RTT_SUMMARY All reduced 1.csv.xlsx

OPA Properties Cleaned (5).yxdb

Shifty

Hey @amcgill2 

I think @apathetichell has answered your question but I've pulled together this workflow to show you how to do each step individually in order.  Hope this makes it easy to follow and to repeat and learn from so you can do this stuff yourself in future. 

Cheers,

Shifty

PROPERTIES.yxmd