Multi Field Filter

[Istwineres]

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]

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

[mot]

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]

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]

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]

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

[afv2688]

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.

Regards

[mot]

Hello @Istwineres,

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

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

[Istwineres]

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

[Istwineres]

Why the join only on A B C and D columns?