Actually iam having headers in two rows for some columns
Example:Iam having start time it is divided into hours and minutes
In first row it is having starttime
below the start time iam having hours and minutes in the next row in different columns
while bulkuploading this hours and minutes should be concatenated and should be inserted into starttime.
you can handle this kind of scinario using flag variable. I have written logic from what I understood from your question.
while(read row one by one)
if (flag ==false)
read row first way
read row second way
concat start time (hours and minutes)
insert row (using varible assignened in first way and second way)
It would be great if you show your input in table format here.
I mentioned flag =0 because
I guess your continues two rows on CSV combines one rocord for you
Am I right?
so to read two lines on csv I used flag=0, when falg is zero it will read first line and when flag is one it will read second line and will insert.
Hi ashalatha, I gave you logic from what I understood. I tried to read your code, but did not get anything why happening so.
One solution is to debug the code while reading every line in the csv and print the values of hours, minutes and start time.
Can you at least give us few lines of the CSV file. It is okay to change the data to something else as long as the structure is the same as the original.
I can't promise you with anything, but I need to see at least few entries on the CSV then I let you know if I can do anything about it. Else, I cannot draw any analysis about the hammer's effeciency without looking at the nail first.