Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

retrieve a row based on a column

nkrupabd
7 - Meteor

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 )

6 REPLIES 6
afv2688
16 - Nebula
16 - Nebula

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
7 - Meteor

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

Christina_H
11 - Bolide

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

nkrupabd
7 - Meteor

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

Christina_H
11 - Bolide

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:

Christina_H_0-1637840418351.png

The output from the filter would be this:

Christina_H_1-1637840442839.png

 

nkrupabd
7 - Meteor

Found the Solution .

Thank you for immediate response.

Really appreciate it.

Labels