community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Need help

Asteroid

Hi,

I need to remove the numbers where each number condition is true. For ex: see my below data. I need to remove 'BBB' and 'DDD' number because each condition of the number is true. Can you help on this? Thanks

NumberConditionTile_NumTile_Sequence_Num
AAATRUE11
AAATRUE12
AAAFALSE13
BBBTRUE21
BBBTRUE22
CCCTRUE31
CCCTRUE32
CCCFALSE33
DDDTRUE41
DDDTRUE42
Pulsar
Pulsar

Hey @Pinky!

 

Attached is a workflow that provides two ways of tackling this issue. The left side uses the usual tools in Alteryx, but the right uses a CReW macro (Only Unique). Both should get you to the output you're looking for, though.

Asteroid

Thank you for your response!

 

I am unable to open Alteryx workflow that you sent it. I am using 10.6 version. Can you explain me the way that you followed or paste the workflow. 

Pulsar
Pulsar

Try this - https://jdunkerley.co.uk/2016/06/29/adjusting-alteryx-files-for-different-versions/

 

Right click on the workflow and edit with Notepad++ then change the version number to 10.6.

Labels