Reframing the whole question, can we change the datatype of column from one datatype to another datatype?
Discussion posts and replies are publicly visible
Hi Sarathkumar R yes we can do it. could give more info about what is the datatype mismatch error?
The database schema currently does not match the CDT mappings (schema-validation: wrong column type encountered in column [amount] in table [`table_name`]; found [int (types#integer)], but expecting [decimal (types#double)]). After the attached database scripts execute, the data store will be successfully imported and saved. The data store will only be published if there are no schema mismatches.
Hi Sarathkumar R
Download the XSD file of the cdt. Edit the column definition to INT or Decimal as per your requirement check from the image below. save the xsd file. open your cdt click on gear icon you will find an option create new version from XSD. click on that upload the latest version of your XSD proceed with create new version
I did the same. We actually changed it from decimal to double and we got some issue. So I am getting confused what might be the reason for the issue. Then we changed it back to decimal and it was working
Hi Sarathkumar R Even it is double on database side, you can still update the XSD version with Number(Decimal) datatype from appian it would not be an issue.
We tried with double on xsd, it was not working. Then we changed it to decimal on xsd. Then it was working. I am just trying to understand what difference does these things make.
Hi Sarathkumar R appian generally considers float, double, decimal into one type of data type which is decimal, generally it happens with text datatype as well, we have varchar long text, string ..etc. but in appian in will be considered as text.Appian allows users to create custom data types using the Record data type, enabling the definition of complex structures tailored to specific requirements.