Alteryx Designer Discussions

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

General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!

Multi Field Filter

Istwineres
8 - Asteroid

I have 6 columns on 4 of them there could be rows with same value. My goal is to filter on the last 2 columns and keep the rows with values (it could be one or both columns) and discard the rows with empty field. In case there are rows with just empty fields in the last 2 columns keep one of them. Many thanks!

Qiu
16 - Nebula

@Istwineres 
Can you kindly provide a sample input and output?

mot
9 - Comet

Hi @Istwineres,

 

It looks like you want to have unique combinations of the 6 columns you have. If that is the case, you can concatenate the columns and use unique tool to have only 1 unique combination for the six columns. After you do that, you can use text to columns tool to get the six columns separated again. Please see the attached workflow. I hope this helps.

 

All the very best!

Istwineres
8 - Asteroid

A    |      B    |    C     |     D     |     E     |     F    |     G

-------------------------------------------------------------------

a    |       b    |     c     |      d     |      e    |     f     |     g               <--- keep this one

a    |      b     |     c     |      d     |      e    | empty| empty

x    |      y     |     z     |      w     |     q     |    l     |  empty          <--- keep this one

x    |     y      |     z     |      w     |     q     | empty| empty           

1   |     2      |   3      |      4      |      5     |empty |empty            <- if unique keep this

afv2688
15 - Aurora
15 - Aurora

Hello @Istwineres ,

 

Since it seems you want to avoid sharing as much information as possible (which is totally fine 🙂 ) I tried to get something as dynamic as possible with my own rules.

 

Hope it helps you.

 

Regards

Istwineres
8 - Asteroid

the 5th row in my example should be kept in the output since it is unique

afv2688
15 - Aurora
15 - Aurora

Hello @Istwineres ,

 

If you would like the order to be kept then this should do it, but in both examples the unique records are kept.

 

Untitled.png

 

Regards

mot
9 - Comet

Hello @Istwineres,

 

I understand your problem better now. This workflow should do the trick.

 

Screen Shot 2021-02-22 at 9.36.31 AM.png

 

I have attached it as well. I hope this helps.

 

 

Istwineres
8 - Asteroid

It seems the right approach but still doesn't work on my input file. The template is the same I managed to write in the original post

Labels