How to merge two data tables

hey @Sunitha_Bist

we can merge two tables into a single table but you should know some points before merging:

**If the number of columns do not match the second table*

  • When the number of columns do not match the second table then it creates blank columns for the table for the column(s) that do not match, as in the following:

If the data type of a column does not match the second table

  • The data types must match. If the column names are the same and if the column name in both tables are the same and the data type is different then it shows the error.

If the column name does not match any in the second table

  • If a column name does not match in the second table then it creates records with a blank in each column that does not match and keeps their own orignal column names.

after this understanding please find this attached sample workflow and let me know :slight_smile: if still you have some doubts on this.

table.xaml (14.4 KB)

Regards…!!
Aksh

5 Likes