Skip to main content
devarnenis2638
March 20, 2024
Question

Records from two tables

  • March 20, 2024
  • 11 replies
  • 0 views

I have two tables with n number of columns out of which mobile number, plan, and amount are common in both tables, we are getting data into tables from two different locations, now i would like to show plan and amount from two tables for which mobile number is same and to be shown in same grid, Can we do this simply without using complex logics and local variables

    11 replies

    karumurua531442
    March 20, 2024

    Hi [mention:54dbd0c9e16846aba7aa0ad377e6fba0:e9ed411860ed4f2ba0265705b8793d05] Just an idea, creating a view in database for the tables using group by mobile number? Or aggregating in appian ?

    stefanhelzle0001
    Brainy
    March 20, 2024

    Sure, use synced records and create a one-to-one relationship. Then you can easily show all data in one grid.

    devarnenis2638
    March 20, 2024

    in both the tables mobile number might repeat multiple times

    stefanhelzle0001
    Brainy
    March 20, 2024

    Well, if there is no clear unique key, it becomes difficult to use record relationships.

    Did you consider to create a database view that merges the two tables?