Add data row question

[A_Learner]

Hi,
I am trying to add a data row to a datatable with Add Data row.
It breaks when one of the columns in in datarow has this value “89MMM49XXXXX” saying it is not a valid Date format. I have no clue why it thinks it is a date. It is just a string. How can I fix this?

Thank you so much,

[Raj_esh (RM)]

Is this the scenario?

[A_Learner]

Correct, there are additional data columns. But it is erroring exactly for this column says not valid Date format. Thank you for looking into this.

[Raj_esh (RM)]

This works fine for me. Hope u are adding the value as string within double quotes

[A_Learner]

I am getting data as csv. Converting CSV to array. And adding this with Add Data row to the data table.

Thank you,

[Yoichi]

Hi,

Do you use GenerateDataTable activity? if yes, can you try to turn off AutoDetectTypes property?

Regards,

[Kanak_Lata_Singh]

Hi @A_Learner

Try to cast all the values you are reading from csv as string type (eg : testValue.ToString()) and then add it to the array.

[A_Learner]

Thank you, @Yoichi
I am using clone to get data table.