Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
_AnonymousUser
Specialist III
Specialist III

CSV Splitter or Filter with Talend Java

We had a requirement today about splitting CSV which as you can see from http://thinkinginsoftware.blogspot.com/2012/10/the-data-team-was-in-need-of.html we resolved with a tJavaFlex component but ideally I think it should be either a new component in Talend or added as a future in existing ones.
The need is to parse an $inputFile using a $delimiter, and output only the lines where the $lookupColumn has a specific $lookupValue (four parameters).
Will this make sense to be added as a feature request? Or the recommended way to go would be to build an in house component? Probably Talend should open a project to host contributions as "talend custom components library"? A google search reveals tutorials on how to build custom components but I believe an open project to host the additional components will only help.
Thanks!
-Nestor
Labels (3)
11 Replies
Anonymous
Not applicable

Hi Shong,
I have added a sample on how to use it in my blog http://thinkinginsoftware.blogspot.com/search?q=csvfilter#talendComponent
This component is really simple. There are 4 params to be used and the picture should be self explanatory.

Cheers,
-Nestor

Cool, Smiley Wink Thank you!
nestoru
Contributor
Contributor

I have added two new features to the component BTW, now it is possible to have the header somewhere in the file other than on the top row. This is handy for some files containing garbage at the beginning. I am also pushing the headers to the output as this is a component to just filter the raw CSV file.
Cheers,
-Nestor