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