Skip to main content
S
shubhamy0001
October 4, 2021
Question

How to merge rows in a grid?

  • October 4, 2021
  • 5 replies
  • 0 views

How everyone,

I have the requirement to merge two or more rown in a grid. An example is shown below:

Col A Col B Col C
1 2 ab
cd
7 9 yz

If the value of col A and col B are same for two rows and Col C value is different then both rows for col A and Col B should be merged.

Thank You

    5 replies

    H
    hrishikeshd997
    October 4, 2021

    Assuming this data is sourced from a database table, the simplest way you can achieve this is by creating a view to merge data across multiple rows using group by clause For e.g. the view query for oracle would be like (here ID is the primary key of the table, you can use any existing columns to order by in this case) -

    select COLA, COLB,  listagg(COLC,',')  within group( order by ID ) MERGED_COLUMN
  from ORACLE_TEST4 group by COLA, COLB;

    For MySQL DB you can use GROUP_CONCAT().

    Once this view is created you can simply source your grid based off this view.

    mikes0011
    mikes0011
    Brainy
    October 4, 2021

    This gets asked a lot, and a quick search came up with at least a dozen different threads containing explanations and design suggestions, for this scenario or ones that are at least similar.

    Here's one from just last week where I provided an answer complete with working code sample: community.appian.com/.../86209

    The Expression Guru
      S
      shubhamy0001Author
      October 14, 2021

      Hi Mike,

      Thank you for the explaination. Since I am getting data from the database row by row individually. Please tell me how can I achieve this.

      mikes0011
      mikes0011
      Brainy
      October 14, 2021

      What exactly do you mean by "getting data .. row by row individually"?  What is the shape of your data (especially, the relationship of the parent rows with the "sub" rows as per your initial screenshots)?  Also -- what have you tried so far, what have you gotten working and what exactly still isn't working?  Thus far, you haven't given us much information to work with or even take guesses at.

      The Expression Guru
      abhayd3663
      abhayd3663
      February 24, 2023

      The exact merge like in excel is not possible in Appian. However it can be achieved by some work-around solutions as suggested by other members.

      One simple solution could be to display as following if it suites to your requirement.

      Terms & ConditionsAccessibility statement