5 Replies Latest reply: Jun 20, 2017 1:31 PM by David Forest RSS

    Combine sales history in excel by week number to current year from SQL

    Jacqui Hat


      I have current transactional sales data from our CRM, and a years worth of weekly historical sales in excel. I have added columns into excel with the week number and season. I have joined this into my CRM transactional table. The CRM table has a sales date.

      I would like to be able to select a week- eg week 5, and the table to display current sales up to the end of that week, with the relevant week from the excel file. How do I categorise my sales dates into these custom weeks.

      I have tried an inline statement, or an if statement in my load clause and I cant seem to get it working - any ideas?