I to have something similar in mind, but not different databases. I would like it if I could change the IP address of my database connections with a variable field you can change on setup if you wan to. Cheers qunu
Hello, i have in a string field a date in this format String ( 02/01/1900 00:00:00) I would like to have it like yyyy-mm-dd in an output field (in string) I use a Tmap1 and i want to include in it. I've try TalendDate.formatDate("yyyy/MM/dd 00:00:00",TalendDate.parseDate("yyyy-MM-dd",row1.dateemission)), but i can't get a good result Exception in component tMap_1 java.lang.RuntimeException: java.text.ParseException: Unparseable date: "02/01/1900 00:00:00" at routines.TalendDate.parseDate(TalendDate.java:87) at blueprint.ekb_p112_expertbo_ais_date.EKB_P112_ExpertBO_AIS_date.tFileInputDelimited_1Process(EKB_P112_ExpertBO_AIS_date.java:947) at blueprint.ekb_p112_expertbo_ais_date.EKB_P112_ExpertBO_AIS_date.runJobInTOS(EKB_P112_ExpertBO_AIS_date.java:3245) at blueprint.ekb_p112_expertbo_ais_date.EKB_P112_ExpertBO_AIS_date.main(EKB_P112_ExpertBO_AIS_date.java:3161) Caused by: java.text.ParseException: Unparseable date: "02/01/1900 00:00:00" at java.text.DateFormat.parse(Unknown Source) at routines.TalendDate.parseDate(TalendDate.java:85)
Hate to dig up an old thread, but this is really bothering me. If I have already created a context in the repository and imported it into my job, how do I then create an additional context and use the same steps to configure two different contexts? When I try to do this using the button on the lower left of the Variables tab under Contexts, it shows me the context in the popup but shows nothing when I try to expand it and select the variables. If you don't create all your contexts before importing the vars in your job you can't use this feature?