Skip to Content

Udf mapping for multiple fields in csv file

May 24, 2017 at 09:29 AM


avatar image


I need help in udf mapping

we are getting csv file in this format. Here the date fields are not fixed, each and every file we get multiple date fields like this 2017-01-22,2017-01-23,2017-01-24,2017-01-25,2017-01-26,,,,,..... Accordingly, the data for each and every date come in a row wise i.e. whether the employee is Attended/Sick Leave.

Require a UDF program in such a way that Mapped ID,NIN,Name,Duration will be one to one mapping and date fields for each employee should be posted in the database table as below output format.

Could anyone help me in this requirement

inputcsv.jpg (27.4 kB)
outputdb.jpg (59.5 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Apu Das May 24, 2017 at 11:28 AM

Hi Ram Mohan,

I guess already you have asked the same question in another blog.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Yes Apu, Could any experts help me?