[resolved]How to pass records to output based on a dynamic column value ?

[HemanthSai]

Hi

I have a requirement to output records with a certain column value which is dynamic.

ColA ColB ColC ColE

1 A 09/15/2021 L

2 B 09/15/2021 M

3 C 09/15/2021 N

4 D 09/15/2021 O

5 E 09/14/2021 P

6 F 09/14/2021 Q

Data is similar to the above table.I want all the records with date 09/15/2021 to output and I do not need rest of the data. In essence I need all the records with the date value in the first record.

I have experimented using tmemorizerows and tjavarow but it did not worked,

Can any one help me with the issue ?

Edit:

Date field is not constant. It comes from a file and then I sort the data based on Date in descending order.

tfileInputDelimited-->tSortorder(based on date)-->somecomponent-->Outputfile(which should have all the records for the top date field )

[HemanthSai]

that solved my issue jeremy thank you.

[gjeremy1617088143]

you're welcome, i'm happy it works