how to just get the first row from the positional file

[_AnonymousUser]

hello,,can someone help me?
My problem is....
there are many records in the file and one column of these record hava same value,i want this value.
So i just want to get the first record from the file.
What should i do?
Example:
id name department
1 jack tech
1 mary tech
1 larry tech
i want to get the department's value.

[janhess]

In the basic settings of tFileInputPositional set Limit to 1

[_AnonymousUser]

In the basic settings of tFileInputPositional set Limit to 1

it works.
thank you very much for your quick reponse

[Anonymous]

There are n number of records in a file. I would like to retrieve first record...please help me ASAP

[Anonymous]

Hi talendetl123,
Are you using positional file? Have you tried to set Limit to 1 in the basic settings of tFileInputPositional?
Best regards
Sabrina