Appian Community and Appian Academy are being upgraded. As a part of the upgrade, Appian Community is currently in read-only mode, and user registration is disabled until August 3. We apologize for any inconvenience this may cause, but a more secure, stable, and performant Community experience is coming soon!

The new Appian Community launches August 3, followed by Appian Academy on August 7. During the migration, Appian Community Edition, Appian Academy, Documentation, Certifications, Instructor-led Customer Training, Partner Sales Training & Accreditation, and Forum (for Appian Partners and Customers only) will remain available.
  • State Suggested Answer
  • Replies 7 replies
  • Answers 1 answer
  • Subscribers 14 subscribers
  • Views 1972 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Data and Records

Comparison for two rows of same record data

pavang5769
Certified Senior Developer

We have a requirement for comparison of same record type data and get the difference of the data & columns. We are aware of "CDT Diff Utilities" which does the same operation and gives the expected output. However we are looking for similar way of plugin availability or workaround to achieve the desired functionality.

Note: We are not looking for manual comparison of the record fields and the data, as we need to perform the comparison across all record types in the application and it will be become very tedious process to achieve by manual comparison.

  Discussion posts and replies are publicly visible

Parents
  • 0
    Appian Employee

    So you can write you own (in Appian). Here's some initial guidance:

    • use a!keys() on your first record instance to extract the record attributes
    • for each extracted attribute, test if recordA[fv!item] = recordB[fv!item]  - if it does, it's a match. If it doesn't then it's not (you could out put the actual values in either or both cases if you wished
    • either way, you can generate a map() with attributes that contain the result, and the values from each record's corresponding attribute 
    • because you can define an expression with rule inputs of 'Any Type' then you could pass in your record instances of any type into that expression and you'd have the generic solution you're looking for

    Out of curiosity, what is the use case here? Are you looking to provide an audit solution that compares two different versions of the data between two rows of data (read into Appian as records)? If so, there's still a missing piece of the puzzle. You will need to be able to map each record/attribute's technical name to a name a business auditor would recognize so that you can present this to an end-user.

Reply
  • 0
    Appian Employee

    So you can write you own (in Appian). Here's some initial guidance:

    • use a!keys() on your first record instance to extract the record attributes
    • for each extracted attribute, test if recordA[fv!item] = recordB[fv!item]  - if it does, it's a match. If it doesn't then it's not (you could out put the actual values in either or both cases if you wished
    • either way, you can generate a map() with attributes that contain the result, and the values from each record's corresponding attribute 
    • because you can define an expression with rule inputs of 'Any Type' then you could pass in your record instances of any type into that expression and you'd have the generic solution you're looking for

    Out of curiosity, what is the use case here? Are you looking to provide an audit solution that compares two different versions of the data between two rows of data (read into Appian as records)? If so, there's still a missing piece of the puzzle. You will need to be able to map each record/attribute's technical name to a name a business auditor would recognize so that you can present this to an end-user.

Children
No Data
© 2026 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.