Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Data model techniques

Dear all,   I have the following 4 transaction tables                    Billing              Collection        Overdue           Bounce                         Loankey,           Loankey,     ...
Need Help
  • erikajain02's avatar
    erikajain02
    8 years ago

    Concatenate all Transational tables as 1 Table with a flag in each to identify them.

    Then Link it with master Table and Calender table for association.

erikajain02's avatar
erikajain02
Resolver I
8 years ago

Concatenate all Transational tables as 1 Table with a flag in each to identify them.

Then Link it with master Table and Calender table for association.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Dear Erika,

     

    I have appended the transanction tables into one still the tables are visible in datamodel.Is it Ok?

     

    Please see the screenshot

     

    • erikajain02's avatar
      erikajain02
      Resolver I
      8 years ago

      Yes...You can also Hide them in Report View to avoid confusion.

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Dear Erika,

         

        While appending the same column names repeating. Here the column Amount repeats again.