Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Output a csv file that shows each employee’s average total pay per pay period. Total pay is computed by summing regular and overtime pay (do not include tax columns). A different pay period is determined by the Pay_Date field. Sort your data so that employees with the highest AvgPayPerPayPeriod are listed first. Your solution should have the following headers: EMP_NO AvgPayPerPayPeriod