Cant Assign with multiple assign

Help Studio
, ,
1

image
image1163×625 39.7 KB

Hi everyone im encountering an issue where im unable to assign values to my variables for which the data taken is from a merged data table above called dt_raw data. Can anyone help to explain the reason why and how to solve this issue?

2

Hi @Benjamin1 Please check the variable type of DateOfApplicationReceived. If it is not “String” then that is the issue.

3

I suggest changing that one to a regular Assign so you’ll get a more informative error message.

4

All the assigned variables i have assigned them a string data type

5

@Benjamin1 If that is the case, then next to check is that you have the correct column name.

CurrentRow("DATE/ TIME APPLICATION RECEIVED").ToString

The extra space after slash seems to be out of the ordinary when there is no space after the word DATE

6

image
This is the error message we are encountering

7

Check whether you are reading datatable including Headers checkbox selecting. If you are reading with Headers Selection, then check the column name correctly. Sometime even one additional spaces also results in Error. Hence, Once please double check the column name and validate the check box selection of include headers while reading data to datatable.

You can check the data in dt_RawData varaible in Immediate panel and validate the column names

8

So resolve that. The column name must be different than what you have in your Assign.