I want to concatenate the three columns on the emp information.
Code: Select all
Source data
ename,eid,eflag
"abc","100","yes"
"bbc","200","new"
"cbc","300","old"
"dbc","400","NA"
output:
ename,eid,eflag,eval
"abc","100","yes","abc100new"
"bbc","200","new","bbc200old"
"cbc","300","old","cbc300NA"
"dbc","400","NA",""
Any help greatly appreciated
Thanks