We're excited to announce that we'll be partnering with Credly starting October 19th - see what this means and read the announcement blog here!

General Discussions

Discuss a wide range of topics! Questions about the Alteryx Platform should be directed to the appropriate Product discussion forum.

Delete columns based on color

Alex
5 - Atom

Hi there,

 

It's possible to delete a column if a particular color (RGB(153, 204, 255) or 16764057) isn't present in any of its row?

Thank you

2 REPLIES 2
patrick_mcauliffe
14 - Magnetar
14 - Magnetar

@Alex  I'm assuming you're talking about an Excel data input? 

If so, the answer is yes.  But its pretty complex, so let me know if I'm on the right track before I continue.

 

Alex
5 - Atom

Hi @Patrick

 

Yes, indeed.

The data comes with this blue color in some cells, and if a column doesn't have any row with blue it should be deleted.

Thank you