Lookup Data Table Not working

Help Studio
1

I keep getting “Lookup Data Table: In the ‘Lookup Column category’ the value for argument ‘Column Name’ is not set or is invalid.” I have tried quotes, no quotes, ToString. Cant figure it out… any help is appreciated

image
image1306×925 121 KB

2

Hi,

Can you check if column named “Org” exists in your datatable. It may be contains extra whitespaces etc.

Regards,

3

Hello

Try this:
Run it again, but this time in Debug mode.
Then check the Locals Panel and review dtZRFTC00004. Screenshot the datatable.

Check the two columns exist:

  • “Org”
  • “Cost Center”

Just use “Org” instead of “Org”.ToString

The lookup value, try assigning this value to variable first.

Cheers

Steve

1 Like
4

@Waterfowl_Waterfowl_hunte

As per error looks like column does not exists

Just to verify…run in debug mode and when fails open locals panel and check the datatable variable values and see if the column is present and the name is exactly matching…mostly it is not present or the name is slightly different

Cheers

5

Please verify column name does exists or not in your datatable.

6

Hi @Waterfowl_Waterfowl_hunte

In Lookup Column box in properties Just give the column name in double quotes instead of writing (.tostring) in it.
And also check that both columns are present in your data Table.

Hope it works!!
Thanks