Excel spreadsheet filtering

[Anonymous]

I have an Excel spreadsheet and I want to ONLY retrieve rows for two types of references.

Reference = "A", "AB", "D","FG"....

How can I bring in only data where Reference IN ("A", "FG")

KUDOS

[Anonymous]

@toscajo I'm afraid you asked this question at the end of what appears to be a completely unrelated post. As such I have moved it. 

In regard to this question, can you elaborate on what it is you want to know please?

[Anonymous]

Hi and Sorry for the wrong area.

I have a huge Excel spreadsheet but only want to use a subset of that in order to be massaged into a new Excel file.

I am very new to talend so only know some with tMap but that won't help as it is for the entire file; I just want a small portion of that filtered by a reference code.  I can use any help on accomplishing this task and Thank You

[Anonymous]

I'm afraid the Talend components essentially treat Excel files as flat files. As such you cannot do what you are asking without consuming all of the data. You may want to look into what @lli has created here (https://exchange.talend.com/#marketplaceproductoverview:marketplace=marketplace%252F1&p=marketplace%...). His Excel components have a very good reputation and may make it easier for you to achieve your goal

[Anonymous]

Thanks and although looks good it doesn't seem to have a filtering piece that would help.  I was wondering if I can use tFilterRows within my process somewhere.... unless tFilterRows only works on tables?

[Anonymous · Accepted solution]

Yes, tFilterRows will do this for me, Thanks and ...

KUDOS

[Anonymous]

The tFilterRow component would work, as would the tMap, but they both work with data that has entered the job. I thought you wanted to try and filter within the file? My thinking was that maybe @lli's components could enable a filter mechanism using Excel's built-in functionality and the ability to make use of it with Talend.