The number of columns in Table 1 and Table 2 is not necessarily the same.
Please help me and tell me what I should do.
The number of columns in Table 1 and Table 2 is not necessarily the same.
Please help me and tell me what I should do.
Use merge datatable activity
Check this link
Hi @kalyanDev
Merge Data Table activity won’t work in the use-case of @zyy_zero considering that the column names are not the same
Then better use .net method dt.Merge(dt2) this work if columns are different
I dont think that would work too.
My suggestion is to create a new table, do a for each loop for every dt and add it row by row to the new dt
I’ve tried this method, but it always turns out like this.
I’ve thought about this method.But I want to find a less time-consuming way.
Try this way DT.Merge(t2, false, MissingSchemaAction.Add); check once else properties of that methods then you get
Hey @kalyanDev,
I also want to know the fastest way of solving this kind of use case
However, there is an error:
Hello, Take a read range activity to read both input excel data and store in a data table and then take merge data table activity and from properties panel, select “Add” in missing schema action and enter data table variable in related field.
Please let me know if it works.
Thank you for your answer, but my question is to merge tables when listing and other items are not identical.
Why don’t you try rest of Missing Schema action of Merge Data table activity?
I’ve created this solution to your problem. The solution is dymanic (it will work even if you continuously update you columns in both DataTables). Attached you will also find the workflow :