Hi,
I am new in Talend. I am stucked at a point.
I want multiple sheet in a single excel output . The number of sheet depend on contain.
let takes an example
main excel
id | category | description
1 | wiki | asdfkj
2 | youtube | asdfhjg
3 | picasa | asdfjkah
4 | wiki | asdfkj
5 | youtube | asdfhjg
6 | picasa | asdfjkah
now based on category i need the sheet should be created . and one more thing category can be more so cannot fixed on 3 or 4 filters
Hi
You must do something wrong, I tested it and it works on v4.2.2. Please upload some screenshot of job, specially the setting of tFixedFlowInput component.
Best regards
Shong
Hi, I have uploade the images. Apart from it my excel format ID | COUNTRY | CITY |WIKI | YTUBE | TITLE1 |YTUBE1 | TITLE1 and i m creating dynamic sheet based on country with regards
Hi
Not sure it was a bug on v4.2.0, I am working on v4.2.2 and it works fine.
Do you install Excel 2003 or 2007/2010 on your machine? Because I install excel 2007 on my machine, so I change the output file name to out.xlsx and it works.
Best regards
Shong
I checked that option and followed what the article said. Now at the output I have an excel with the desired sheets, but the problem is that the sheets are "empthy". I am using Talend Enterprise 5.4.2. No data is passed through the components tFlowtoIterate and tFixedFlowInput. I am not expecting them to catch values, but they don't let previous outputs from components such as tFileInputDelimited or tFileInputExcel or any other output mappings to be used within further mappings.
Real Solution: You have to define a key (local global variable) in the tFlowToIterate for each column that you want at output. After tFixedFlowInput you add a tMap where you map each output desired column with one of the local defined global variable in the tFlowToIterate.
In the attachment you can find some pictures with detailed information on how this works.
Pictures to solution LINK from my dropbox account to a zip file containing 6 small screenshots.
