Jump to content

rickaroo62

Members
  • Content Count

    1
  • Joined

  • Last visited

Community Reputation

0 Neutral

About rickaroo62

  • Rank
    Newbie
  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...