Transpose the datatable

[SunnyJha]

Hi, i have a datatable dt which needs to transposed to do further operation.

input dt:-

output dt:-

As you can see in the transpose datatable I dont need the “Mapping” column and the column headers from the input dt.

@Yoichi

[vrdabberu (Varunraj Dabberu)]

HI @SunnyJha

Check the below thread:

How to transpose datatable?

@SunnyJha You can follow the steps Delete the first column as you dont need usign delete data row Now use generate datatable activity and pass the string as String.Join(",",dt.AsEnumerable.Select(function(x) x(0).ToString)) and select comma as row separator and check the header box Delete the column which you want as headers also the second one Now use for loop with loop on all columns dt.Columns Now inside use add data row and in the arrayrow property pass String.Join(",",dt.AsEnumerable.Sel…

Regards

[SunnyJha]

I had tried this but wasn’t able to understand.

[hammad_rafiq (hammad rafiq tukdi)]

Hey @SunnyJha

Try This.

[ppr (Peter Preuss)]

@SunnyJha
Give a try at this starter help

Variables:

Flow:

kwr = dtData.DefaultView.ToTable(False, {"Keyword"})
Add DataColumn Details:

dtTransposed = 
(From i In Enumerable.Range(0, dtData.Columns.Count).Skip(2) 
Let ra = dtData.AsEnumerable.Select(Function (x) x(i)).ToArray
Select r = dtTransposed.Rows.Add(ra)).CopyToDataTable

[vrdabberu (Varunraj Dabberu)]

HI @SunnyJha

Xaml:
Sequence51.xaml (8.6 KB)

Input:
Input 7.xlsx (9.0 KB)

Screenshot:

Regards

[vrdabberu (Varunraj Dabberu)]

Hi @SunnyJha

You can use the below workflow also:

Sequence:
Sequence51.xaml (10.9 KB)

Input:
Input 7.xlsx (9.5 KB)

Screenshot:

Regards

[SunnyJha]

Thanks Petr. I made some modifications on your logic and its working as per my need. Thanks again!