Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Delete entire data in first 2 columns keeping the headers.

Nobbie369
6 - Meteoroid

Hi All,

 

I am span-new to Alteryx, looking for someone's help in deleting entire values in the first 2 sheets of my excel keeping the headers. Can somebody throw some light on this? 

4 REPLIES 4
binuacs
21 - Polaris

@Nobbie369 Sample attached

image.png

Nobbie369
6 - Meteoroid

Thanks @binuacs for you quick response. Sorry, I made a mistake in the question. I actually wanted to delete data from first two columns of my sheet keeping the headers. I know I wasted your time, but would you be able to provide one sample for this workflow, really appreciate your efforts. 

dwstada
11 - Bolide

@Nobbie369 you can delete the contents of a column by "replacing" it with null using a formula tool

 

nobbie369.PNG

Nobbie369
6 - Meteoroid

Thanks @dwstada

Labels
Top Solution Authors