hi shicong

the example in which i am using is a scenario like after loading the data in db from excel and if i want to add one more colum and load the data is it possible in talend and how i need scren shot so that in db the first load data would be

my input  excel is and input in database should be
==============
Name    DOB    AGE
Andi    6/12/2001    10
Agus    7/11/2001    NULL
Baba    2/14/2005    NULL

comments colums is added by teacher regarding the student performance and wants to add a new colum in the existing database

Name    DOB    AGE            comments
==============================

Andi    6/12/2001    10             good
Agus    7/11/2001    NULL        very good
Baba    2/14/2005    NULL         ok



Scenario 2

i want to calculate age when dob is given in excel and load into database so my input file will be

input file is excel

Name    DOB    AGE
===============
Andi    6/12/2001    10
Agus    7/11/2001    NULL
Baba    2/14/2005    NULL
=================

and after loading into databse the out put of age should be with current date

output in DB or excel should be

Name    DOB    AGE
================
Andi    6/12/2001    10
Agus    7/11/2001    20
Baba    2/14/2005    30



i hope i replied your question, please sent me screen shot how to do it using talend