recently learned how to use the invoke method importrow to process and append a datarow to a datatable.
i am getting the following erro
message: input string was not in a correct format.couldn’t store < > in a Patient Cell Column. expected type is decimal
patient cell column is the name of a column and it is a decimal type. from my reading this error means that datarow being appended is blank on this column.
how do i pass this blank cell through the invoke method import row activity without erroring out? how should i handle this? being blank is intentional and i would like to keep the cell blank since not every row will have a cell phone number.