Compute and Create New TSeq
A
1
=demo.query("select EID, NAME+?+SURNAME as FULLNAME, GENDER, STATE, BIRTHDAY, SALARY from EMPLOYEE"," ")
2
=A1.new(FULLNAME:EName,if (GENDER =="M", "Male","Female"):Gender)
3
=A1.new(EID, FULLNAME, interval@y(BIRTHDAY,now()):Age)

Of A2 and A3 the computation results are as follows: