Creating link with data in a cell, from another cell of the same row

lakshman553

hi,

could be a cakewalk for some people but being very new to data tables, i am finding it difficult to achieve the following:

my json data structured in csv looks this will be:

EmpId, EmpNum, EmpName
1,E01,John
2,E02,Doe
3,E03,Bill

I want my datatable in the following way

EmpNum,EmpName
E01,John
E02,Doe
E03,Bill

The hyperlink reference on E01 should be emprof.aspx?empid=1, for E02 it should be emprof.aspx?empid=2... and so on...

i know columnDefs is a way forward for me but somehow unable to crack it.

Any quick help please. thank you.