I am using DataRow as TransactionItem to process some data inside an REF.
The number of columns may vary, in the sense that there may be 2 or more columns with names like this: TimePeriod 1, Timeperiod 2,…, Timeperiod X.
In short, i needto get the “X” and my thought process was to loop through the column names using an index and find out what “X” is.
In a datatable i could do this using a For Each column in DataTable, and use column.ColumnName, like so:
Is there a way to do this, assuming i have to do it on the DataRow? The column name info is there, i just need to get to it
If it is always incremental column names as you say, “TimePeriod 1”, “TimePeriod 2” etc, why not just count the number of columns?
var = datatable.columns.count.tostring
then the column name can be assumed to be "TimePeriod " + var
List_columnnames = dt.columns.columnnanes.tolist
This will give you a list containing column names.
Using index will be of second priority. Try using column header names to fetch data in case of dynamic datatable.
Thank you both for your responses! They are valid and super useful insofar as we are talking about columns in a DataTable.
However, my question is reffering to the case where, for example, in a workflow file we have an In argument of type DataRow (let’s call it “OneRow”). There is no DataTable in this workflow.
So, to rephrase the question, is it possible to retrieve the column names for a variable or argument of type DataRow, assuming there is no DataTable involved?
Hope that is clearer. Thank you!
Hi @Serban ,
You can get the column names from DataRow by using (datarow).Table.Columns and this will return “DataColumnCollection”.
You have loop the DataColumnCollection object. For Each (DataColumn).ColumnName to get the column name.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.