How to merge 2 data table with specific columns

Hi All,

I have excel sheet in that “Directory number” column iam looping in for each row i will get out put after executing query i want to update same excel with output how to do that that.
image Output

Hi @thima,

if you want to append the data below this data only you can use append range activity from uipath, just you have to pass the sheet name and datatable .

Thanks,
Shikhar

Yes i tried this but its not appending properly. Its appending from middle of the sheet

Does the sheet and the datatable you are appending are having same headers ?

Yes first time its writing second time appending from middle of the sheetappend.xlsx (12.3 KB)

Hi @thima,

Can u provide sample inputs and expected output in excel?

Thanks!