Expression Doesn't Produce a Value

Help Activities
, ,
1

Hi Team,

I wanted to Insert a new column after “Snippet A Run Date” column called “Snippet A Run Date Status” In a data table called dt_Input. I tried the below expression in the image, but it is saying Expression Doesn’t Produce a Value please help me to resolve this issue.image

2

Hi,

DataColumn.SetOrdinal method returns nothing as the following. So we need to use Invoke Method activity instead of Assign.

Regards,

3

@Yoichi Can you help me how to do the same in Invoke Method Activity as I am not sure about the column position number to pass the ordinal number directly.

4

Hi,

Can you try as the following image?

img20210302-2
img20210302-2771×472 17.1 KB

Regards,

5

@Yoichi Getting the error as image

6

Hi,

This error message says dt_input or dt_input.Columns("Sinppet A Run Date Status") is null. So can you check your datatable (such as the dataable is initialized? columnname is correct? etc.)?

Regards,

7

@Yoichi column Name “Snippet A Run Date” is there in the data table, Please see below image.

image
image609×505 23.6 KB

8

Hi,

I just got your situation. We need to set Add DataColumn Activity, first. Next call SetOrdinal as the following. Can you try this?

img20210302-3
img20210302-3958×481 39.9 KB

Regards,

1 Like
9

@Yoichi It worked now… Thank you so much :slightly_smiling_face:

1 Like
10

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