How to delete all row in a input file

[Anjankumar2021]

Hi Team, need to delete all rows in input file except headers. Pls assist.

[Anjankumar2021]

How to delete all rows and unwanted columns in my input file

[binuacs]

@Anjankumar2021 to delete all the data from your input file you can use the MultiField tool and replace with Null()

[RobertOdera · Accepted solution]

Hi, @Anjankumar2021 

To clarify, you want to delete all rows = only headers, correct?

For that, consider using the Select Records tool.

Making the field values of the columns Null() or Blank will not remove the rows, as info.

Please mark it as an acceptable solution if it works for you - cheers!

 

[apathetichell]

I'm might be reading this wrong - but you want this in your actual input file? like you want to read in the headers and then overwrite the file? That is what you are asking about so I just want to be clear:

Input data tool - input your full path. click the box that says "first row contains data". Hook up an output data tool. Click on the bottom section to overwrite sheet or range. Unclick the "include filename in output" box - and swap this to full path to your filename field. Make sure you are configured to overwrite sheet or range - and make sure you are configured to skip your field headers. You now have a blank excel sheet except your headers - which is what you asked for.

[RobertOdera]

You're most welcome @Anjankumar2021 

Please let the community know if you need anything else - Cheers!