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, INT16. 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 (i.e., 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 172,000 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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!