Hi everyone. My issue is the following: i have an excel workbook and use a read range activity to output in a data table dt1. I’m trying to make another data table dt2 with the same structure as dt1 but keep only the headers and write them in another excel workbook. i did the following:
- Read Range Activity - Input:Excel Workbook 1 Output: dt1
- Assign activity - dt2 = dt1.clone()
- Write Range Activity - Excel Workbook 2
The Excel Workbook 2 is empty without any headers.
I need to mention the fact that in both read range and write range activity the “Add Headers” option is ticked.
Your help will be highly appreciated!