Make second row of datatable to be the header

Hi,

Can you try the following steps?

  1. Read whole data as string using Read Text File Activity.
  2. Remove 1st row using Regex.Replace method (or Replace activity) (Pattern should be "^.*\n" )
  3. Convert string to datatable using Generate DataTable activity.

Hope the following image helps you.

Regards,

6 Likes