DSXchange

source one column name is id
1
2
3

i want target is

id
1
2
3
1
2
3
1
2
3
how you it

Hi All, I have a job, to capitolizing 1st and last letters. Source Column_name-varchar mphasis satyam techmahindra wipro ibm Target Column_name-varchar MphasiS SatyaM TechmahindrA WiprO IbM Thanks Vijayasarathi

Hi All, I have a job, I want the count of the Each department number. Source File: DEPTNO, SAL 10, 1000 10, 1100 10, 1200 20, 1100 20, 1200 30, 1200 30, 1300 30, 1400 Target File: Count 1 2 3 1 2 1 2 3 Thanks, Vijayasarathi