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
20 - Arcturus

@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