Neelakanth_Patil a year ago Hi @Retroflame Aggregator will return the max value of date field, Just make sure you add correct group by columns.

> We can use ' Distinct ' property in Sorter Transformation to eliminate records from flat file or relational sources, but we can't use source qualifier SQL override for flat files. > But If you …

Hi Gurus, I want to count distinct values for one column group by PK. can any body show me how to achive this in INFA. I can use select count (disitnct) in query, but just wondering if there is …

Prad.Kann 10 years ago I found using the last function along with aggregator and joiner helps to identify the last record. I created two source definition reading from the same file. The first …

Aggregator outputs last row Hi, I was asked a question on aggregator transformation that I didn't know answer for so I thought I will ask here to see if someone can help. Why aggregator …

Hi Community, I've been using the Aggregator plugin for a while now for a number of functions, mainly for deduping. Right now I am trying to use it in a DSS task over approx 838K rows but …

D, 1 Now pass the output of expression transformation, aggregator transformation to joiner transformation and join on the products port. In the joiner transformation check the property …

Aggregator transformation without selecting group by clause!! If we ignore to select group by clause in an aggregator transformation ,what will be the output?

This can be achieved in the following three steps :- 1) Expression transformation :- use a iff condition to define the columns with the particular string and where err_cd=0 2) Aggregator : …

Expand Post Digv.Bhos 11 years ago Hi Prasanna, I think in this scenario we should use sorted to get distinct records.Because to get distinct data from aggregator we need to select all ports as …