How to Remove Column header and make row zero column header?

[Jay_Chacko (JC)]

I have successfully used the ‘data scraping’ activities and extracted table data from an application. below is the metadata property

	<extract-table get_columns_name='2' get_empty_columns='2' columns_name_source='Longest' />

The resulting data table Structure is returned like this

[Column-2,Column-3,Column-4,Column-5,Column-6,Column-7,Column-8,Column-9,Column-10,Column-11
Acct ID,Patient Name,Acct Status,Class,Adm Dt,Dis Dt,Prim Payor,Tot Chgs,SP Bal,Tot Bal

I want the column names of the data table to be like below and remove the 'column-2,column-2-3 etc

Acct ID,Patient Name,Acct Status,Class,Adm Dt,Dis Dt,Prim Payor,Tot Chgs,SP Bal,Tot Bal

how to do i achieve this without using any excel activities? . is there a way to edit the meta data , so the unwanted headers will never show?

I have tried below without success

datatable.AsEnumerable.Skip(0).CopyToDataTable

Please advise

[Yoichi]

Hi,

Can you try the following?

Regards,

[Jay_Chacko (JC)]

thanks this worked