How can I remove all the headers

I have a table with 6 columns each having a header.
Before a “for each” activity i want to remove all the headers.
How shall i do it?
Any suggestions?

@diptojyotidutta In the read range activity uncheck headers so it won’t read table headers

1 Like

Hi @diptojyotidutta,

In read range activity, you can uncheck Add headers property.

Hi @indra and @SaiKrishna147
I am not using read range activity as i am fetching the datatable directly from my database

@diptojyotidutta You can skip first row so it will skip column headers write query like this

  Assign Dt = Dt.AsEnumerable.Skip(1).CopyToDataTable
2 Likes

It skips 1st row and header still appears

.AsEnumerable.Skip(0).CopyToDataTable

This will remove the header from the output datatable. @sonikasingh20
Thanks
Happy Automation