topic Re: Extract particular fields by using Talend in Talend Studio

Extract particular fields by using Talend

Anonymous — Mon, 13 Nov 2017 13:17:57 GMT

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.

Re: Extract particular fields by using Talend

Anonymous — Mon, 13 Nov 2017 14:11:43 GMT

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.

extractRecords.png

Re: Extract particular fields by using Talend

TRF — Mon, 13 Nov 2017 20:39:11 GMT

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

Re: Extract particular fields by using Talend

Anonymous — Tue, 14 Nov 2017 04:30:50 GMT

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.

Re: Extract particular fields by using Talend

TRF — Tue, 14 Nov 2017 07:18:53 GMT

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

Re: Extract particular fields by using Talend

Anonymous — Tue, 14 Nov 2017 07:21:26 GMT

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