topic Re: Skip Excel columns in Talend Studio

Skip Excel columns

Anonymous — Sat, 02 Mar 2013 09:05:21 GMT

I have an excel input in which there are 8 columns. I want to create an output which has data from 1st, 7th & 8th column only. So can I achieve this in talend?
I tried to use tInputExcel & then I edited the schema so that I kept only column number 1, 7 & 8. But when I ran the job, talend extracted data for columns 1,2 & 3 instead of 1,7 & 8. So is there any way to tell talend to skip column numbers 2 to 6?
Thanks in advance.

Re: Skip Excel columns

Anonymous — Sat, 02 Mar 2013 09:17:01 GMT

I think I figured this out. I used tMap component in which I mapped only required columns. So basically my input has all 8 columns which goes to tMap & output from tMap has only 1, 7 & 8 columns. This worked fine. Thanks

Re: Skip Excel columns

Anonymous — Sat, 02 Mar 2013 09:35:54 GMT

Hi,
It is a good job. I'm here to share my demo job to you. My workflow is tFileInputexcel-->tFilterColumn-->tFileoutputExcel. see my screenshots
For more details, please see the component reference tFilterColumns
Best regards
Sabrina

Re: Skip Excel columns

Anonymous — Sat, 02 Mar 2013 09:58:58 GMT

Yes, I think this is lot better than using tMap. tFilterColumns suits best for my requirement. So thanks for showing correct solution.

Re: Skip Excel columns

Anonymous — Mon, 04 Mar 2013 02:39:36 GMT

Hi venky_194,
We have promoted Talend Help Center to community guests which provides a structured source of enriched information and knowledge, certified by Talend, where you can quickly and easily find out how to make best use of the full range of Talend products, hope it will be helpful for your further work.
Best regards
Sabrina