Jump to content

rickaroo62

Members
  • Posts

    1
  • Joined

  • Last visited

rickaroo62's Achievements

Newbie

Newbie (1/7)

0

Reputation

  1. I have a huge file with multiple rows per CustomerIDs and Dates. There's a second field called PRODUCT which has various two digits text codes. I want to accomplish two things 1) Convert the date to YYYY-MM 2) for all the combinations of CustomerID and YYYY-MM, I want to count the number of times each PRODUCT occurs. Attached is a sample of 6-7 customers. Thanks Sample for Counting and SQL help.xlsx
×
×
  • Create New...