Merge Datatable Replace blank column

Help
, ,
1

Hello everyone,

I hope you are doing well.

I am facing an issue and I would appreciate if anyone help me to fix this.
I have two data table(without header) and want to merge them to a new datatable and add header to that merge datatable, but for 2nd datatable the first column is empty so after merging bot replacing the blank row with next row of data so I am getting datatable with wrong column arrangement. Please advise me on this:

image
image1213×634 46.6 KB
test1.xlsx (8.7 KB) [test2.xlsx|attachment]
(upload://5wXYgX96Rn1GO5qRvJgaOQm8T4m.xlsx) (8.6 KB)
imagetest2.xlsx (8.6 KB)

2

Hi @koushik!

For the 2nd datatable you need to add a empty column first, change it to the first position and then do the merge.

To do this, use “Add Data Column” activity to add a column in the 2nd datatable and then follow the instructions on the solution of this post: Add Column and make it as the FIrst Column - #2 by Jan_Brian_Despi to make it the first one. Finally, do the merge with the 1st datatable.

Hope it helps,
Best Regards

3

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.