Could anyone please let me know how can I design a job where I am reading from multiple excel files and loading it to a database. I could create separate jobs each having its own
texcelfileread ----> tMap --> tOracle texcelfileread ----> tMap --> tOracle texcelfileread ----> tMap --> tOracle so on... But I would like to design in the below way or any other efficient way that you can suggest :
So here I collect all the data from 3 excel files first then apply any transformations any then load it to tOracle component. Kindly let know your suggestions asap.
Hi, Have you tried to design the workflow as:tFileList( set the file mask as *.xlsx to get your 3 excel files )-->tfileinputexcel(same schema structure)-->tMap(further processing)-->tOracleOutput? TalendHelpCenter:tFileList component is usually used to iterate on files or folders of a set directory. Best regards Sabrina
Thanks Sabrina,
Will check that,
Could you please also let me know this error I am getting,I know there are several topics for date and I followed those,still I am facing the issue as below :
Type mismatch: cannot convert from String to Date
1) In tMap component I am using the below 3 columns.The dates are hard coded :
TalendDate.formatDate("dd-MMM-yyyy", TalendDate.parseDate("dd-MMM-yyyy", "29-FEB-2016")).toUpperCase()
TalendDate.getDate("dd-MMM-YYYY").toUpperCase()
TalendDate.formatDate("dd-MMM-yyyy", TalendDate.parseDate("dd-MMM-yyyy", "31-DEC-1991")).toUpperCase()
2) In tMap the out metadata is in the below format :
Type : Date , date pattern : "dd-MMM-yyyy"
Type : Date , date pattern : "dd-MMM-yyyy"
Type : Date , date pattern : "dd-MMM-yyyy"
Could you please tell what change is required.
Hi, Actually, TalendDate.formatDate(String, Date) return "String" and TalendDate.parseDate(String, String) return "Date"(Your outout is "Date" type). You have to parse it as Date type. Such as, TalendDate.parseDate("yyyy-MM-dd",TalendDate.formatDate("dd/MM/yyyy")) Best regards Sabrina
