Multi Field Filter

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!

Datasets

Developer Tools

Common Use Cases

Best Practices

Expression

Data Investigation

Accepted answers

All comments

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!

concatandunique.yxmd

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

keep lines.yxmd

mot

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.

unique_combo.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703