Hi Team, I wants to join 2 datatable in below format. please check and help me on this.
In “A” Column all header should be there and in “B” column values should be there.
and it should keep adding row below.
but in your output I can see header are on 1st row, I my case I need all header in 1st column.
Also column name are not common in my table
-
for this one you cannot do that via Merge Data Table
Just Assign one dictionary and store all headers from column first and there respective value to there key . -
Create one data table with headers
-
After that just use for each assign that data into the created data table
-
once after appending data from dictionary, Use Remove Data row activity and remove Header from Schema
Anil_G
jast1631
donghai
gulsheen_kaur1