We created a CDT called "Extraction_details" in Appian, which contains 36 fields such as "effective date," "agent name," "company name," and others.
For each field, we provided an array, resulting in the automatic creation of corresponding database tables.
Now, we are trying to create a view for these tables to display all the related data for a single "extraction_Id". But we are getting repetitive rows and data is being multiplied which is causing us more issues.
This is related to the query https://community.appian.com/discussions/f/general/35170/need-to-export-process-variable-data-in-a-pm-to-a-formatted-excel-sheet by RithwinV2000
Is view creation possible?? If so can anyone guide us with it.Thanks in advance,
Discussion posts and replies are publicly visible
Using CDTs, nesting CDTs and making primitive type fields an array clearly violates the Appian best practices around data modelling.
Do you have any specific reason to do this?
https://docs.appian.com/suite/help/24.2/data-modeling-with-appian-records.html
We have 43 fields, and each field needs to accept multiple values. If we use relationships, we would need 43 CDTs,...any suggestion for this ?
Is this about document extraction? In this case, you would store the extracted data of a single document to a single record.
Now, what steps do you do after extraction? In such a situation, I would try to transform this data into a meaningful data structure before further processing.