I have two files in a folder and I want to merge the data from both the files and write into another excel. Tried with Merge Data Table but didn’t get it. @Palaniyappan
Make sure you have same column headers while merging the data table @balkishan
Yes, I don’t have any columns, I already removed the columns, I only need the data not the columns name.
In addition to Hareesh, make sure the number of columns match in the excel files.
Yes number of columns are also same bro…
Make sure these things buddy
—hope you have the datatable of both the excel files ready
—if so make sure that we have
Same order of columns
Same name of columns
Same number of columns
Same datatype of columns
Only then we can merge them
Yes bro, Columns name I don’t have, I have direct data, and the number of columns are same in both the excel. Just want to merge and put it into another excel sheet.
And make sure that we have enabled the ADD HEADERS property in the read range of both the excel files
So we have only records
I have these files in a folder. So do I need to put into diff - 2 folder. Or I can read from one folder only.
Yes, Exactly bro.
May I know why we have neglected the headers
That’s not a issue we can read the file and merge them even if they are in same folder
Because bro. I want to merge these excels data once merged this data into another excel,
I want to copy the entire data into the MasterFile. Master file already contains the Headers.
So what is the issue here bro. Do we need headers in both the files.
Can’t we read without headers.
Yah kindly enable the headers while getting them
And while writing the Master file we can append range
Okay, I added the headers in both the excel. Now guide me.
I have these files in single folder.
First I want to merge these files data into single sheet, Then I want to copy the entire data into Master, I think it’s easy to do.
Yah now we can get the data from them with read range activity and merge them using merge datatable activity
Then we can take the destination mentioned datatable as input to the append range activity
In Merge Data only Destination and Source option are given.
But we have two DT variable one for first and second for another excel. right me if I am wrong.
Yah keep the one in source and another one in destination
Finally we can take the destination one as it will have the merged data,and use that in append range activity