Hi Folks
I need some help I am getting a csv file of some data and its not in the format I want. I want to take that csv import it into a table and then manipulate that data and make a new table with it.
My information looks like this...
My header column the numbers 0 through 23 represent hours of the day 0 being midnight
CUSTOMERNUMBER,Date,0,1,2,3,4,5,6,7,8,9,10,11,12,1 3,14,15,16,17,18,19,20,21,22,23
100002,20160208,2.359,2.599,2.702,2.827,2.59,2.959 ,3.283,3.443,2.981,3.204,6.099,2.53,2.479,3.818,11 .269,8.183,5.817,4.555,2.042,4.052,2.481,3.337,6.2 79,3.732
100003,20160208,2.228,2.055,2.304,2.069,2.257,1.38 ,2.191,1.426,2.212,1.509,1.995,1.474,1.517,0.459,1 .552,1.755,5.165,0.965,2.669,0.614,0.567,1.247,4.9 36,3.864
100005,20160208,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0
100006,20160208,3.127,2.214,2.367,2.781,2.734,3.10 1,2.726,3.191,2.302,4.514,3.202,3.623,2.75,2.168,2 .053,3.199,2.634,2.384,1.943,3.644,2.487,3.831,3.5 04,2.252
I need it to look more like this.
CustomerNumber, Date & HOUR,Usage
100002,20160208 0:00,2.359
100002,20160208 1:00,2.599
100002,20160208 2:00,2.827
100002,20160208 3:00,2.59
ect.....
Seems like something a query could do then just make it a make table query and so on...
Your help is appreciated.
Thank you
CapJLP