1

I want to do something like Read only certain columns from xls in Jaspersoft ETL Express 5.4.1, but I don't know the schema of the files. However, from what I read here, it looks like I can only do this with the Enterprise Version's Dynamic Schema thing.

Is there no other way?

Community
  • 1
  • 1
StorymasterQ
  • 264
  • 2
  • 17

1 Answers1

0

you can do it using tMap component. design job like below. 

tFileInputExcel--main--TMap---main--youroutput
  1. create metadata for your input file that is excel
  2. then used this metadata in your input component
  3. in Tmap select only required columns in output.

See the image of tMap wherein i am selecting only two columns from input flow. enter image description here

Enterprise version has many features and dynamic schema is the most important one. But as far as your concern that is not required. it is required if you have variable of schema wherein you don`t know how many columns you will received in your feed.

UmeshR
  • 803
  • 1
  • 9
  • 16
  • Actually, what I wanted was just that, the ability to read Excel files without first knowing the incoming schema. I may not have articulated it well enough in the OP. I'll change that now. – StorymasterQ Jan 08 '15 at 00:16
  • In that case you have to use Dynamic schema feature in Talend subscription version. – UmeshR Jan 08 '15 at 06:44