4 Replies Latest reply: Nov 10, 2016 11:22 AM by Andrew Gutierrez RSS

    Crosstable load with different data types

    Andrew Gutierrez

      Hello all. I have a question regarding how to approach this load. I have a CSV that has information for 2015 and 2016.  I am unable to make changes to and have approached this using a cross table load. The problem is the data for the crosstable has two different data type similar to the structure found below.

      IDLocationPracticeRateJan 2016Feb 2016Mar 2016Jan 2016Feb 2016Mar 2016
      1NAFinance$2001510$30$90150$
      2NASales$400200$0$180090$

      Now I have tried using crosstables to make (Months, Hours) and use a master calender to populate missing dates but I am unable to use the data values it correctly as the currency value gets factored in along with the hours so each month has a combined data value. The second set of 2016 dates has currency data that is ( Rate x Hour ) so would it be possible to load all the hours and calculate to populate a table after ?

       

      If it makes it easier, I wish to have my data in this type of manner to create visualizations off as I think this would make it easiest to work with compared to the form it is now.

      IDLocationPractice RateMonthHoursRevenue
      1NAFinance$200Jan 20161$30
      1NAFinance$200Feb 20165$90
      1NAFinance$200Mar 201610$150
      2NASales$40Jan 20160$0