hi.. i want to know that is it possible to load the data into excel sheets? If so then how to load 1-50 records into 1st sheet,51-100 records into 2nd excel sheet and so on up to 5 sheets of a single excel file. Please help me how to do this.. Thanks..
Hi Shong, Am able to write to multiple sheets using the above job design. But i need to write data into next sheet once the first sheet gets filled up with data in maximum no of rows(65K).. My input will incrementally increase.. Manoj
Hi Change the no of records to 65k , context.sheetName="Sheet"+(input_row.id/65000+1); Best regards Shong
During above idea implementation , am getting 2 sheets in excel as my number of rows is 90K. But in those sheets there are only one record in each sheet. I mean ,in the first sheet the 65th thousand record is there in first row and similarly the same happens in second sheet. I thin the data is over written. Plz guide me further. Manoj
Hi Manoj /Shong/Sabrina, I am unable to see job design i have some 10 million records which i want to write in excel sheets , sheet name can be sheet0, sheet1 or sheet2 as it use to be default i am unable to write in multiple sheets can you please show me job design , i want to implement same as Manoj requirement is "But i need to write data into next sheet once the first sheet gets filled up with data in maximum no of rows(65K).. My input will incrementally increase.."