Full support for drill-through using ReturnCSVTableHandle
Is your feature request related to a problem? Please describe.
Arc already uses TI running ReturnCSVTableHandle function to populate the preview for TI with text file datasource. And a drill-through process which uses the ReturnCSVTableHandle rather than ReturnViewHandle function also works already in Arc and Slice but not 100%. When a drill-through uses the ReturnCSVTableHandle function the resulting handsontable grid displays the Excel column headers A, B, C, D, etc. rather than the variable names or the contents of the first row of the text file where DatasourceASCIIHeaderRecords=1.
Describe the solution you'd like
The resulting grid from using ReturnCSVTableHandle in a drill-through process should respect the DatasourceASCIIHeaderRecords and take the contents of the last record skipped and display this as the column headers. However, if that is not possible then the names of the variables in the drill process should be used. Excel headers should only be used if no variable names are set.
Describe alternatives you've considered
None.
Screenshots
In TI editor for datasource preview and configuring variables Arc uses ReturnCSVTableHandle in a unbound TI process to fetch the file contents. The header records are correctly handled and the contents of the last row of header records are used as the column headers.
If a drill-through process is defined to use ReturnCSVTableHandle then this just works in Arc/Slice except that the header records are not correctly handled as column headers and "Excel column headers" (A,B,C,D,etc.) are displayed in the drill result table.
If DatasourceASCIIHeaderRecords=1 then the 1st row is eliminated but the column headers remain A,B,C,etc. The column header values should come either from the file itself or from the variables tab of the process which would give the developer some freedom to set the values.