We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun 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