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 )
