Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Column 'TIMESLOT' cannot be null
Column 'TIMESLOT' cannot be null
These are the errors i am getting while running the job..and also in my database its taking 0 value for the extra excel column
Hi Yves
I am expecting that all you sheets have same schema.
If yes, If all sheets is checked in tFileInputExcel; talend read all the sheets from the excel in one go no iterate is required.
in the next tMap, add an extra column (SheetName) and value for the column is ((String)globalMap.get("tFileInputExcel_1_CURRENT_SHEET")).
This value will change based on sheets name so basically if there are are 5 sheets, the column SheetName will have 5 unique value.
tFileInputExcel--------tMap-------tFileOutput
row1 row2
For writing into output file, you can specify the filename as <Location>\row2.SheetName+<extension> with append option clicked
here a seperate output will be created for each unique value of SheetName column.
Hope it help you
@ravishankar.m
Can you explain what is the error you are getting?