How to copy the Value of the each header in file 1 to file 2 ?
If you want the column A as header from file 1, follow the below steps:
Thanks & Regards,
I don’t find “Use transpose datatable” activity in studio
You want only the headers or the values as well ?
Hi @Sathish_Kumar_S ,
If you are looking for a dynamic approach, then here you go:
(From c In Enumerable.Range(1,dt_sampleData.ColumnCount-1) Let rowItem = Enumerable.Range(0,dt_sampleData.Rows.Count).Select(Function(s) dt_sampleData.Rows(s)(c)).ToArray() Select dt_result.Rows.Add(rowItem)).CopyToDataTable()
TransposeDataTable.xaml (8.2 KB)
Could you please show output for this.