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.

       

       

       

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Dear Erika ,

       

      I have appended 4 transaction tables but data is loaded only for 1st table.Flag is available only for first table.

       

       

      • erikajain02's avatar
        erikajain02
        Resolver I
        8 years ago

        This sould not be the case.

         

        Can you share your file with us or dummy data ?