In CDT How to handle the table without having primary key?

Not. Appian requires a primary key. If you do not have one, you could create a view that adds an artificial PK.

How can we update the data in that table if we are creating the view?

If you are creating a view, simply add a new column for the artificial or composite key.

CREATE VIEW my_view AS
SELECT col1, col2, CONCAT(col1, '_', col2) AS composite_key
FROM my_table;

We cannot update data in view, data should be update in the Table then how we can update the table?

If you are going to update the table, then why not just add an auto-increment id column?

Why do you have one table without a primary key? Add it with autoincrement at least , and you will we able to create your cdt.

ankitas209 said:

then how we can handle this table in Appian

By updating it to add a Primary Key column.