Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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
binu_acs
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