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.

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 ?

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Please send me ur email id.I will share the file.