Update Column in Data Table

[Nicki]

Hi Allan,

is there a way to update one column in “for each datarow”? I read a csv to Data Table and add a column. I tried assign row(16) = “TEST” but it doesn’t work.

Thanks for your great work!

[Allan_Zimmermann]

Yes, you can UPDATE using the syntax you showed, but you cannot ADD a column like that
You need to use add column activity for that.

[Nicki]

Hello Allan,

I tried to add column:

Is this the right way? Column is added but when I try to add values it doesn’t work

[Allan_Zimmermann]

what error are you getting ?

[Nicki]

Hello Allan,

thanks for your reply. I found the solution:

Change Default Value 0 MaxLength

[Allan_Zimmermann]

I am glad you found a solution.