Question: Prep Data for Further Analysis Now you need to fix the date fields, Transaction date and Posted date. Create two new date fields from the
Prep Data for Further Analysis Now you need to fix the date fields, Transaction date and Posted date. Create two new date fields from the existing text date fields removing the time component. Look at your data to choose the correct incoming format. Give the new fields descriptive names. Remove all transactions that have a null Transaction Date. Now that you have the date fields in a date format and have removed null dates, compute common fields you will use later. Compute two new fields, Year and Month, from your new Transaction Date field. Make sure both new fields are integers, INT You do not need to create fields from your new Posted Date field. Create a new field CardholderName, which combines the Cardholder Last Name and Cardholder First Initial fields with a space between them ie Erdem O Remove the following unneeded fields o Original Transaction Date o Original Posted Date o Cardholder Last o Cardholder First Initial You are only interested in transactions from EU Make sure to filter transactions so you only analyze those that pertain to Erdem University. Sort the data by transaction id This will be the last step in your workflow and there should be approximately records. Put a Browse tool at the end of your workflow to show the correct records.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
