Pradeep, can you provide more detail as to the behavior you are seeking? Also, can you provide more detail about where your transformation is failing? Do you have an example ktr you can provide?
Here's what I understand. You have a data file where the first row header includes strong representing a data-time. You wish to extract that date-time, interrogate it, and determine the desired treatment of the detailed data. Please correct me if incorrect.