need to merge a csv file using external tables into a main table
978578Dec 7 2012 — edited Dec 7 2012Hi,
I have a csv file which contains the date(with time stamp), column1(number),column2(number), column3 (number). I am using external tables concept to load the data froom csv to this external table and then merging into the main table. Problem here is : the csv file is a system generated file and nothing can be edited under it. our aim is to automate this process of loading data from csv to the table. In this csv the date time stamp is not in the proper format.I mean the date is not visible and only minutes and seconds are visible.By changing the format in csv manually this can be overcome.but we donot need any manual intervention.
how can i overcome this problem ?? please help mee...
Excels data looks like:
(PDH-TSV 4.0) (India Standard Time)(-330) \\DISAPPSER01\Processor(_Total)\% Privileged Time \\DISAPPSER01\Processor(_Total)\% Processor Time \\DISAPPSER01\Web Service(_Total)\Current Connections
56:59.0 47
57:09.0 0.72379582 4.204561281 46
57:19.0 0.916548537 4.006179927 44
57:29.0 0.663034771 3.674662541 43
57:39.0 0.750789844 4.093933999 42
57:49.0 0.721538487 2.650858026 40
57:59.0 0.594781604 3.333393703 40