Im getting error in lookup data table

Lookup Data Table: In the ‘Target Column category’ the value for argument ‘Column Name’ is not set or is invalid.

image


@sathish_Kumar6

As per error either the column name you gave is wrong or is missing in the table please check the same

cheers

checked column name but it seems to be correct and the column name is also coming as same in local

check if there is a space in the column name in excel. So STATE NAME looks correct but is not the fully name

@sathish_Kumar6

check for any extra spaces or so…

Also check if you are sending the right datatable

cheers

As an alternate use the immediate panel and type in: raw_dump.Columns

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

chaged data table now im getting null value in output like Message Box: Object reference not set to an instance of an object. so what could be the reason?

yeah checked no spaces there ppr

ok will try it later for sure

@sathish_Kumar6

If you are getting object reference error then there is no data in your datatable

cheers

Hi,

Can you try to output and share the result of the following expression? We can know even if there is zero-width character in column name.

String.Join(",",raw_dump.Columns(1).ColumnName.Select(Function(c) AscW(c).ToString))

Regards,

check within the immediate panel and share with us the result, thanks

KINDLY NOTE:
the values within the STATE NAME columns are not case matching (sometimes lower case, sometimes upper case. E.G.: (Excel1) TELANGANA vs. (Excel2) Telangana

So even when the the column name issue is solved, the lookup will not find the matching statename. We would recommend to handle it by

  • a constructed lookup dictionary
    OR
  • a LINQ statement

im getting output like this

image

How to do this both?

Data is there but it different like uppercase and lowercase

Hi,

Thank you for sharing. it’s merchant-order-id. Is this from raw_dump? In your image, the 2nd column of raw_dump datatable is “STAT…”

Regards,

Assign Activity:
dictLK | Dictionary(Of String, String) =

dt2.AsEnumerable.ToDictionary(Function (x) x("STATE NAME").toString.ToUpper.Trim, Function (x) x("RS Code").toString.Trim)

Then you can access with the dt1 State Name Value .ToUpper.Trim the dictionary and retrieve the RS Code

Yes how did you know that’s great… yeah for testing i have created this column and it is coming at second so i will share you updated excel header file please look like if you could do any use of it.

All columns.xlsx (31.0 KB)

Need to give this in for each row… could you please let me know how to implement this?