retrieve a row based on a column

[nkrupabd]

Hi i'm looking for a solution where we can extract a whole row based on a column.

example we have a column names 
when the user enters a name the solution should return the whole info of that person(whole row of that name )

[afv2688]

Hello @nkrupabd ,

Could you set up an example for me to understand what is really what you are looking for. I don't quite understand it.

Regards

[nkrupabd]

if user gives paycode act we need to output all the rows corresponding to that column value(act)

[Christina_H]

It sounds like you just need a filter tool, [paycode]='act'

[nkrupabd]

there are multiple such rows instead of filter tool do we have any other way please

[Christina_H]

A filter tool splits the data stream into those that match and those that don't, the T output anchor will have all rows matching the condition.  Can you explain why this isn't what you want?

E.g. extending your input data to this:

The output from the filter would be this:

[nkrupabd]

Found the Solution .

Thank you for immediate response.

Really appreciate it.