Using DataView.ToTable Method as input to a Write Range


#1

Hi there,
I’m trying to extract a single column from a DataTable variable and to use this column as an input to a Write Range Activity. The following method should return a DataTable which could be used as an input, but I haven’t figured it out yet.

The VB Expression for the Data Table input that would return a datatable made from the column 0 of a given dt DataTable variable would be something like
dt.DefaultView.ToTable(false, dt.Columns(0).ColumnName)
but it awaits an identifier ?
I’ll keep looking into this, in the mean time if you have any comments you’re welcome =)

rookie mistake the [0] was used instead of the (0)