[resolved] Count matches in join tMap

One Star

[resolved] Count matches in join tMap

I have a problem, I want count the number of like for each feed. How i can do it?
Thanks

Seventeen Stars

Re: [resolved] Count matches in join tMap

Connect an output component to your flow and use its return value NB_LINE to get the number (after the flow has been finished this return value is set). As a simple output you could use tJavaRow (without coding anything it like /dev/null ;-)
One Star

Re: [resolved] Count matches in join tMap

Can you help me with example, please.
My problem is count the number of matches between feed and like.

id_feed          id_like   id_feed                  output_feed_id         out_number_like
X                    a           X                           X                               3
Y                    b           Y                           Y                               2
                      c           X
                     d            X
                      e           Y
One Star

Re: [resolved] Count matches in join tMap

use tAggregateRow on lookup file/table for count and then join in tmap.
One Star

Re: [resolved] Count matches in join tMap

 I use tAggregateRow for count and then i use result in tMap, good
One Star

Re: [resolved] Count matches in join tMap

Take lookup table with tAggregateRow and in tAggregateRow output schema take 2 columns one from input schema i.e id_feed and
userdefine 2nd one i.e name it as COUNT (datatype integer) and apply Group by on id_feed.

please look screenshots for more clarification



2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Have you checked out Talend’s 2019 Summer release yet?

Find out about Talend's 2019 Summer release

Blog

Talend Summer 2019 – What’s New?

Talend continues to revolutionize how businesses leverage speed and manage scale

Watch Now

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog