Hi Hema don't use merge collection please use append rows to collection. It will work for sure I have tested its working fine.Hi Amlan,
Thanks for your response.
I tried in the same way but it throws error at the merge stage (as I have same headers on all the 4 sheets)
Internal : Could not execute code stage because exception thrown by code stage: A column named 'name' already belongs to this DataTable.
Please let me know how to remove the headers on rest of the sheets except the first.
Hi Amlan,
It works now. Thank you for your swift response.