DataTable within a DataTable - Code Stage
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
20-07-16 08:05 PM
Hi,
I am trying to use code stage to return a Collection that also has a collection inside and I'm having trouble with creating a DataTable that has a column with type DataTable. Any thoughts regarding the approach on this?
Needing your expert advice.
Thanks,
Ed
2 REPLIES 2
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
04-08-16 09:56 PM
Hi Ed,
Here is some example code that you can use to add a nested datatable column
'Declare a new Datatable
Dim dt As DataTable = New DataTable
'Add your Columns
dt.Columns.Add(""ID"", GetType(Integer))
dt.Columns.Add(""Value"", GetType(DataTable))
'Add a row
dt.Rows.Add()
'Assign your output collection
col_Out = dt
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
18-08-16 04:52 PM
Hi baumannf,
This is great! Thanks!
Ed
