Hi i would like to use merge datatable activity but would like to ask what would happen if both datatables only have one common column, and i would like to merge all columns according to that common column.
eg. Table 1
to become Table 3
Name Age Address
A 11 USA
B 12 UK
Refer this post
Join Two Data table
Use below code to remove empty row from the table.
Use assign activity
DataTableName=DataTableName.Rows.Cast(Of DataRow)().Where(Function(row) Not row.ItemArray.All(Function(field) field Is DBNull.Value Or field.Equals(""))).CopyToDataTable()
Re-usable Component pass Parameter as datatable you will get the answer.
RemoveEmptyRows.xaml (8.5 KB)
Remove rows based on particular column is empty.
DataTableName.Select("Convert(column3, System.String)< >''"…
May I ask if it is possible to join two datatable with different number of rows?
The truth is, I have 3 datatables which share one common column.
Table 1 is the main column, for example holds the below data:
Then there is Table 2 which holds information for A and C
There is also Table 3 which holds information for B
As you can see Table 2 and 3 will bring in new columns to Table 1. None of their new columns will be the same as each other, so does the rows (if table 2 holds information for A, A won’t appear in B)
The reason I want to join these tables together is mainly cause I needed the column “Age” from Table 1. If there’re better ways to do this, please advise.
Thank you very much.
You can follow below tutorial,