Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Need Help

sabihaS
7 - Meteor

Hello Everyone,

 

I want to extract values where it is tick(x) from below column, for e.g. in this case I need to extract DEF and XYZ, Please can some one help me on this.

 

col1 

ABC 
DEF x
GHI
XYZ x

 

Result:

DEF

XYZ

 

Thank you in advance :)

8 REPLIES 8
NidhiSethi
6 - Meteoroid

Hi Sabiha,
Try filter tool with the suitable condition, the data doesnt provide enough to create a condition but if you do find a pattern we can try something.

alexnajm
18 - Pollux
18 - Pollux

Sounds like a Filter tool! Where [Tick]=“x”

NidhiSethi
6 - Meteoroid

Yeah, please accept the answer once it works.

sabihaS
7 - Meteor

Thank you for your reply. Sorry I have modify my query(it was incorrect earlier). Please can you again check the query. Thank you.

alexnajm
18 - Pollux
18 - Pollux

You will still need a Filter to reduce the rows down to 2., in this case use EndsWith([col1], “x”). Then use a Left([col1], 3) to extract the first three characters of each line

sabihaS
7 - Meteor

Thank you for your reply. I tried but its not getting filtered properly, not sure what I am missing. Please can you have a look at workflow. Thank you.

binuacs
21 - Polaris

@sabihaS seems to be your data is in single cell,

image.png

alexnajm
18 - Pollux
18 - Pollux

That workflow shows exactly what you've described above IF they are separated into different cells

 

If they are not like you've tried to demonstrate, then you need a Text to Columns tool before the filter to split to rows on \n (aka newline)

Labels
Top Solution Authors