Assign: Column 'Nullable (Y/N)' does not belong to table DataTable

Help Studio
, ,
1

Hi,
I keep getting this error: Assign: Column does not belong to table DataTable. This is how I have it in my Assign. Was trying to compare two excel spreadsheet. Thanks

image
image465Ă—335 12 KB

image
image929Ă—134 4.39 KB

image
image689Ă—112 3.35 KB

2

Hi @choudhury

Can you please show the contents of dtsheet1?

Is there actually a column named “column”?

3

Column is Header if that makes sense..:
image

4

Hi,

There might be some invisible character b/w in the column name.
So, can you share result of the following expression using LogMessage activity etc?

 String.Join(",",dtSheet1.Columns(intIndexForTheColumn).ColumnName.Select(Function(c) AscW(c)))

note: intIndexForTheColumn is index number of the column. We can replace it with integer literal.

Regards,

5

Where to put that code in Yoichi?

image
image885Ă—629 27.8 KB

6

Hi,

It’s OK anywhere if dtSheet1 have been read.
For example, as the following point.

image
image885Ă—629 27.9 KB

You can also use the expression in immediate panel in debug mode with breakpoint.

Regards,

7

I have put it like this as the position you mentioned and go the following:

image
image950Ă—490 15.3 KB

Error:

image
image1066Ă—475 29.1 KB

8

Hi,

It seems wrong index number because the result is “Column”.
So can you try 5 instead of 3 (or other) as index number?

Regards,

9

Tried with 5. What do you mean by “or other”? I did not get that one. Thanks a lot for your prompt reply. Much appreciated.

image
image724Ă—134 7.31 KB

image
image794Ă—274 13.5 KB

10

Hi,

The result shows line feed character exists in the column name. So can you try to use the following expression as the column name?

"Nullable "+vblf+"(Y/N)"

For example

rowSheet1("Nullable "+vblf+"(Y/N)").ToString.Trim.ToLower

Regards,

1 Like
11

Thank you. That worked. I do not see any error and the script ran. Much appreciated.

2 Likes