I have created a view and it has data in it . I am creating cdt and trying to map that into DS but it is not hapenning showing error
"One or more of the data entities cannot be mapped to the table structure in the selected data source. Please choose an option for creating the necessary tables or select a type that matches the existing tables. (More Info)"
More info "The data source schema does not match the type mappings: Missing column: a_id in Appian.report_isr_budget_study (APNX-2-4056-000) "
.
Discussion posts and replies are publicly visible
Hi Akshay,
Seems like you have not defined the primary key in your CDT. Defining the primary key will resolve this issue.
Need a key for your view
Suggest to refer
docs.appian.com/.../Mapping_CDTs_to_Pre-defined_Database_Tables.html