Extract particular fields by using Talend

[Anonymous]

Here my question :

Generate 1000 records (1.... 1000) as input.

Expected output: - 1, 100, 200,300,400,500,600,700,800,900,1000  these 11 records alone. 

Please help me to find this.

Thankyou.

[Anonymous]

Hello Gurumahesh,

A job like this one may answer your question. (see attached document)

In this job, I have a ".csv" file in input. This "csv" contains only one column with records from 1 to 1000.

In the "Var expression", I filter on the values I want in output.

My output is a ".csv" file too.

I hope this job will help you.

TD

extractRecords.png

[TRF]

Hi,
Don't know where does the value -1 come from...
From others, you may use the following tmap output expression filter:
row1.value % 100 == 0

[Anonymous]

Thankyou for your reply tdz,

but, If you have more fields how can we extract? Here 1000 rows so we can use this but one million records then we can't able to give every particular row right?

So how to get all first row and all multiples of 100 .

Please let me know if you are not able to get this.

[TRF]

Not able to get this!
Give us an input sample and the corresponding expected result.

[Anonymous · Accepted solution]

Thankyou for your support.

It worked for me now

i used MOD function for this 

Mathematical.MOD(row4.Value,100)==0||row4.Value==1

Thankyou