topic Count filter value in column in Talend Studio

Count filter value in column

Anonymous — Sat, 16 Nov 2024 07:03:56 GMT

Hello friends, help me please.

1- I have a tmap and in this component I make a filter.

filter:

2- I would like to store the amount of "D" or "N" generated by this filter to be used in a context.

Sorry for my english

Re: Count filter value in column

Anonymous — Thu, 13 Dec 2018 04:30:18 GMT

Hi,

One of the easiest way is to use a tjavarow after tMap to do the count. Please note that this is one among many solutions you can create for this scenario. The steps are as below.

a) Create two context variables called D_count and N_count and assign the initial values as zero.

b) Connect a tjavarow after tMap and assign all the output columns as pass through fields from input columns. You can use automapping functionality in tjavarow since your schema remains same

eg:- output_row.filler=input_row.filler

c) Add a if condition at the end of mapping in javarow to check the value of FLAG_VENDA. The pseudo code is as shown below.

if (FLAG_VENDA.equals("D))

{

context.D_count=context.D_count+1;

}

You need to add the condition for both values (D and N) and you will get the counts to context variables for later use 🙂 Please make sure that you are not having any null values to this field as equals() function will throw error.

If the answer has helped you, could you please mark the topic as resolved? Kudos are also welcome 🙂

Warm Regards,

Nikhil Thampi

Re: Count filter value in column

dramya — Wed, 06 May 2020 04:42:24 GMT

Hi Nikhil,

I have similar query to count the ID from the source file and seperate them in to 2 different columns as Single & Multiple Entry becoz ID will be unique for multiple entries & some ID do not have multiple entries. I want to get the count details based on the Numbers and segrate that value in seperate column.

Is it feasible ?

Angel