Hi,
Thanks for your answer. I will try to speak in comprehensible english
:
My first Job work fine, its certainly not optimize but it's work. i must generate an patient's directory for an vocal standard from informix database. i describes you my lasts components :
After tMap, request and other i have in output two csv files. This two file have got the same schemas :
-iddossier
-nom (name)
-nma (married name)
-prenom
-sexe
-den
-dso
-service
-chambre
I merges this two file with tUnit component (same schemas) on a csv output file (same schemas). The problem is that : In my database for married women , the married name is insert into "nma" and maiden name in "nom". In my directory i want the married name and not "nom".
I just want for some lines of my csv who have got a married name, swhitch this column into "nom". I hope you understand
For that between tUnit and ouput csv i have add an tJavaRow, i have clik on generate code and i add to that little code of java (i don't know java).
"output_row.iddossier = input_row.iddossier;
output_row.nom_pat = input_row.nom_pat;
output_row.nma_pat = input_row.nma_pat;
if (input_row.nma_pat != null) {
output_row.nom_pat = input_row.nma_pat;
output_row.nma_pat = "";}
else { output_row.nom_pat = input_row.nom_pat;}
output_row.pre_pat = input_row.pre_pat;
output_row.sex_pat = input_row.sex_pat;
output_row.den_dossier = input_row.den_dossier;
output_row.dso_dossier = input_row.dso_dossier;
output_row.ser_dos = input_row.ser_dos;
output_row.nch_sej = input_row.nch_sej;"
That work because all the "nm"a are put in "nom" collumn, thats i want. But all others name's without married name (male or women not married) disappear.
I hope u are understand what i want to do.