Part #1 Input, Clean & Combine files

Your engagement manager instructed you to input both Excel files into Alteryx and take the necessary

steps to pre-process and cleanse the data for audit procedures, such as:

o Remove any null rows or columns.

O Use similar case for all string fields with characters.

o Ensure all data types are appropriate.

o Note (applicable to all parts): Any dollar amount fields should be in Fixed Decimal format

size 19.6. Account number should be a string field.

Join the Prior Period TB file with the Current Year Activity file.