Column Value Error

Help Studio
, ,
1

Hi All,

I want to get the Column values of each row and for that I am using the below code .The output data table is correctly displaying two column names QuoteNumber and Mismatched Data. However when I am using it shows the column name “Mismatched Data” does not belong to data table

image
image984×222 9.76 KB

image
image1734×512 30.9 KB

image
image1362×1278 40.7 KB

1 Like
2

Hi @marina.dutta

Instead of giving like that, try the below one by using column index,

- Assign -> out_value_mismatch = CurrentRow(1).toString

Use the same to first column,

- Assign -> out_value_Quote = CurrentRow(0).toString

Hope it helps!!

3

Please make sure below points before referring the column names in the assign activity:

  • The AddHeaders in the property is checked
  • The column name has any trialing or leading characters
4

Try using index
Currentrow(0).ToString

check are you giving the column exactly which is available in your datatable.

5

whenever we are in doubts we can

  • debug / along with brekapoints
  • inspect / trace the variables using the debugging panels
  • doing RnD and prototypings within the immediate panel

Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - News / Tutorials - UiPath Community Forum

So in you case use : Unmatched_dt.Columns
within the immediate panel and check the offered columns

6

Hi,

It seems you have to trim your Excel headers.

Use below query to trim the Excel headers

dt = (From col In dt.Columns.Cast(Of DataColumn)()
Select New DataColumn With {.ColumnName = col.ColumnName.Trim()}
).CopyToDataTable()

7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.