i have a txt file and contains lot of data and i need only start and end rows between data only

[chandurai126]

Hi,
i have TXT file and it contains lot of data and data having startdate and end date is there .But i need only in between Data.

Example:

100 records in source

5 Row  is start date and 16 Row is end date 

33 row is start date and 40th row is end date like that

But we need only 6 to 15 and 33 to 40 data.

Regards,

Chandu 

[Shicong_Hong]

@chandurai126 You can't filter the data directly on tFileInputDelimited that read the data from txt file, read all data from txt file and then filter the data on tFilterRow or tMap component. Each row contains a Date data? 

Regards

Shicong

[ThWabi]

Hello Chandu,

if the row numbers are always the same as in your example, check out the tSampleRow component.

Regards,

Thomas