One Star

how to just get the first row from the positional file

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.
4 REPLIES
One Star

Re: how to just get the first row from the positional file

In the basic settings of tFileInputPositional set Limit to 1
One Star

Re: how to just get the first row from the positional file

In the basic settings of tFileInputPositional set Limit to 1

it works.
thank you very much for your quick reponse
One Star

Re: how to just get the first row from the positional file

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

Re: how to just get the first row from the positional file

Hi talendetl123,
Are you using positional file? Have you tried to set Limit to 1 in the basic settings of tFileInputPositional?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.