Talend community forum / discard non matching rows

pgmuthukumar · 2012-05-30 09:23:32

HI,

Need help to implement the below.
1. we are getting data feed in a file
2. we just need to filter out rows with valid product codes
- valid product codes are available in our database table
3. push the rows with valid product codes to the staging table

Thank you.

pedro · 2012-05-30 09:32:47

Hi

You might use tMap to do inner join.

Regards,
Pedro

pgmuthukumar · 2012-05-30 10:31:50

thanks Pedro, Inner join works perfectly well.

pgmuthukumar · 2012-06-01 07:43:48

Hi,
Is there a way to filter out measures with non zero rows only.

Thanks,

pedro · 2012-06-01 07:50:54

Hi

You might try the tFilterRows component. Or you set filter condition in tMap.

Regards,
Pedro

pgmuthukumar · 2012-06-01 09:09:46

Hi,
Tried tFilterRows component, thank you.

I fear some of the values are truncated while converting bigdecimal to int using one of the methods - toIntValue() or toIntValueExact(). So not sure how to proceed further.

Instead load the data into a staging table and get only non zero values in query panel.

Advice if the above method is right or could I have tune this better.

Thank you.

pgmuthukumar · 2012-06-01 10:56:22

input please

pedro · 2012-06-01 11:11:02

Hi

According to your description, the condition->operator should be 'not equal to'.

Could you show the code about methods toIntValue() or toIntValueExact()?

Regards,
Pedro

Announcement

Unanswered posts

#1 2012-05-30 09:23:32

discard non matching rows

#2 2012-05-30 09:32:47

Re: discard non matching rows

#3 2012-05-30 10:31:50

Re: discard non matching rows

#4 2012-06-01 07:43:48

Re: discard non matching rows

#5 2012-06-01 07:50:54

Re: discard non matching rows

#6 2012-06-01 09:09:46

Re: discard non matching rows

#7 2012-06-01 10:56:22

Re: discard non matching rows

#8 2012-06-01 11:11:02

Re: discard non matching rows

Board footer