Skip to main content
Known Participant
Feb 12, 2024 11:04 AM UTC
Question

Database Table with 100+ Columns

Hi, everyone! So we have a database table that has 100+ columns. But in Appian, record types have a limit of 100 when it comes to number of record fields.

Is creating a 2nd record type sourcing from the same table an appropriate solution for this? If not, what would be the ideal way of doing this? Would gladly appreciate your help. 

    2 replies

    harshitb6843
    Brainy
    Feb 12, 2024 11:31 AM UTC

    Yes. Having more than 100 columns in a record is anyway a bad idea. I think creating a second record and moving similar types of fields there, connected with the primary/base record using a record relationship (one-to-one) should be the right thing to do. 

    stefanhelzle0001
    Brainy
    Feb 12, 2024 11:39 AM UTC

    What do you want to do with that data? Do you need any of the features that only records can do? If not, you could just use a data entity.