Hi guys,
is it possible to merge datatable 1 (has one sheet, lets call it “ABC”) and datatable 2 (has one sheet lets call it “DEF”)? In the end my ideal output would be datatable 1 with sheet “ABC” and sheet “DEF” in it. So I’d like to say "sheet DEF, move to datatable 1". I’d like to avoid having a 3rd “output” Excel.
Thanks in Advance!
Regards
Marco
→ Use Read Range Workbook to read both the sheets ABC and DEF and store the output in a datatable say for ABC sheet Dt_ABC and for DEF sheet Dt_DEF.
→ Use Merge Data Table activity:
Give source as Dt_DEF
Give Destiantion as Dt_ABC
→ Write Range Workbook Dt_ABC to the seperate sheet in the excel.
Regards
Okey thank you guys! This does work.
But as it seems it does not take over the formatting. Are there any options or settings to keep the format (like column width and colored cells) ? Or am I suppose to do it after merging?
@vrdabberu @rlgandu @Vinit_Mhatre
Regards
Marco
Please do raise an new query regarding this by sharing the input and expected output. I will help you out.
Regards
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
