rickaroo62 Posted February 29, 2020 Share Posted February 29, 2020 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 Link to comment Share on other sites More sharing options...
Funce Posted March 4, 2020 Share Posted March 4, 2020 Is the Spreadsheet an example of the SQL layout, or are you trying to update a spreadsheet? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now