How to remove the second row as column header in Table Extraction

[dutta.marina (rpa_06)]

Hi All,

I am trying to extract Table extraction activity and store in data Table. I am getting below as Column-0. I want to delete the first row and make the second row as column headers.

[lrtetala (Lakshman Reddy)]

Hi @dutta.marina

Use a for loop with dt.Columns and change type argument to datacolumn

Inside the loop use currentitem.ColumnName = dt.Rows(0)(currentitem.ColumnName).ToString

After the loop use assign to remove the first row as below dt = dt.AsEnumerable.Skip(1).CopyToDataTable

Or use remove data row activity

Hope this helps

[Yoichi]

Hi,

The following post will help you.

Not able to get Column Name in Extract Data Table

Hi, Can you try as the following? This renames columns using items of the 1st row then remove the 1st row. [image] currentItem.ColumnName=ExtractDataTable.Rows(0)(idx).ToString Regards,

Regards,

[raja.arslankhan (Raja Muhammad Arslan khan)]

@dutta.marina
use Remove Data Row and give it First row

[dutta.marina (rpa_06)]

Hi Lakshman ,

I did the same way mentioned however I am getting an error. I had similar issue in my previous code and tried the following u mentioned and it worked .However in this case I am getting the error.

“Assign: Exception has been thrown by the target of an invocation.”

[lrtetala (Lakshman Reddy)]

Can u show the output panel SS

[dutta.marina (rpa_06)]

@lrtetala

[dutta.marina (rpa_06)]

@Yoichi

I tried but it did not work.

[raja.arslankhan (Raja Muhammad Arslan khan)]

@dutta.marina inside loop…print values. I am pretty sure its giving error in last column

[lrtetala (Lakshman Reddy)]

@dutta.marina
Following post helps you

Getting error "assign exception has been thrown by the target of an invocation"

Hi all! Although this reply comes very late, I’m going to leave it here as it may help others who encounter such an issue in the future. The exception in this message (although it seems vague) shows that the Assign is not the source of the exception. In this case it’s useful to have a look at the exception details; there, you can find the clue as to what happened. [image] In my case (and I believe this is also what happened to others) it was this: Cannot set column ‘XXXX’. The value violate…

[dutta.marina (rpa_06)]

@raja.arslankhan

This is the values inside for loop.

[Yoichi]

Hi,

I guess there are some empty cell in the first row.
Can you try to add the following condition of If activity, then assign column name?

ExtractDataTable.Rows(0)(idx).ToString<>""

Regards,