Filter by Column Header

[LeslieB87]

Hi All,

I would like to apply a filter to column headers in 2 senses.

1) if it contains a certain column, I would like it to filter for true

2) if it does not contain the column, it would filter out on the false side.

Say for instance I have data set that has:

Name, number, date, invoice and total purchases

If the data contains the invoice, it should proceed to the true part, if not to the false part.

This is due different structures, where 1 "shop" provides an invoice number and the other doesn't.

Would it be possible?

Thanks

[LeslieB87]

Hi All,

I would like to apply a filter to column headers in 2 senses.

1) if it contains a certain column, I would like it to filter for true

2) if it does not contain the column, it would filter out on the false side.

Say for instance I have data set that has:

Name, number, date, invoice and total purchases

If the data contains the invoice, it should proceed to the true part, if not to the false part.

This is due different structures, where 1 "shop" provides an invoice number and the other doesn't.

Would it be possible?

Thanks

[atcodedog05 · Accepted solution]

Hi @LeslieB87 

Here is how you can do it.

Workflow:

Hope this helps : )

[atcodedog05]

Happy to help : ) @LeslieB87 

Cheers and have a nice day!