Hi folks, hope someone can help me out here.
Problem is as follows:
In some sequence I define a data table (DT1) using the build data table activity and then I use an assign activity to assign an extract of a different data table to DT1. So what I’m doing is this:
Build data table: DT1 (header1, header2, header3, etc…)
Assign: DT1 = DT2.AsEnumerable.Skip(x).Take(x).CopyToDataTable
The problem is that the headers I define in DT1 don’t work correctly. When I try to write DT1 to an Excel sheet, I get this instead of the column names I defined:
Does anyone have a clue why this is? Some of the columns in the extract are empty, but I compensate for that by allowing null values in the appropriate columns in DT1.