Hi,
Can anyone help, i’m trying to output values to my datatable but theyre being shown as ‘System.Collections.Generic.IEnumerable`1[System.Object]’ in the datatable
Scenario
I’m trying to read 2 columns from an excel file (columns A & AW) and store the values in an into column 1 and column 2 of my datatable
I can read the columns from excel spreadsheet and successfully store the values into column1 & column2 objects
Column 1 imports fine into the datatable via ‘Add Datarow’ activity inside a ‘For each’ loop and shows the correct values that were gathered from the spreadsheet
The values shown in column 2 however are shown as ‘System.Collections.Generic.IEnumerable`1[System.Object]’ and i’m not sure how to convert that value into a readable value
For column 2 i used an ‘Update row item’ activity inside a ‘For each row in data table’