How to Appending 3 excel sheets for one excel up filtering

[Tharusha_Fernando (Fernando ✔️)]

i m planning to append 3 tables few columns to one datatable like this with a condition of unique rows based on Attbribute2 do some one know how to append

[Nithinkrishna]

Hey @Tharusha_Fernando,

I hope that can be done.

But could you please elaborate your scenario a bit with specific column names and provide sample excel.

That will help resolve this.

Thanks

[Tharusha_Fernando (Fernando ✔️)]

hi @Nithinkrishna
thanks for the reply Book1.xlsx (8.5 KB) Book2.xlsx (8.5 KB) Book3.xlsx (8.5 KB)

these are the datatable which i required to append
{Date,Attbribute2(should be unique),discription,Dr,Cr} are the data coloum name which i should include in result sheet with data FInalbook.xlsx (9.5 KB)
as much as i run i should keep the gap between 3 tables
hope u have an idea

[Nithinkrishna]

Hey @Tharusha_Fernando,

Please find this workaround this may help.

ExcelConsolidation.zip (29.0 KB)

Also, please check the output file.

Thanks

[Tharusha_Fernando (Fernando ✔️)]

thanks you @Nithinkrishna its very helpfull

[balupad14 (Balamurugan)]

Hi @Nithinkrishna,

It will keep the format ?

Thank you
Balamurugan.S

[Nithinkrishna]

Yep @balupad14, It will

Thanks…