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 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.

     

     

     

     

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Dear Erika,

         

        I have sent the sample.

         

        I have created a link table with the fields (AccountNo,Amount,MonthYr,Flag,Key)from the tables Register,Billing,Bounce,Overdue,Collection .And then I have connected the link table with Register , Billing,Bounce,Overdue,Collection with Key and Link table to the calendar with MonthYr.