Forum Discussion

HR6776's avatar
HR6776
New Member
2 years ago
Solved

Adding Data from Excel into Existing Table with no Relationship

This is my first post asking for help and would really appreciate any advice or info that will help me achieve what I need to do!  I'll try and explain as best I can what the problem I am having is: ...
Need Help
  • MFelix's avatar
    MFelix
    2 years ago

    Hi HR6776 ,

     

    If both your tables (current + Excel) have dates then you can use a calendar table has a dimension to make the relationship between both tables then you can make a sum of the current with the count of the excel table.

     

    Since you only have the month on the excel you need to assume for the start of the month or the end of the month has a date for those excel cases and then  you have  a way of getting your information to the month level, and even day however the Excel ones will be on a specific data on the month that you need to consider in your assumptions.

MFelix's avatar
MFelix
Super User
2 years ago

Hi HR6776 ,

 

If both your tables (current + Excel) have dates then you can use a calendar table has a dimension to make the relationship between both tables then you can make a sum of the current with the count of the excel table.

 

Since you only have the month on the excel you need to assume for the start of the month or the end of the month has a date for those excel cases and then  you have  a way of getting your information to the month level, and even day however the Excel ones will be on a specific data on the month that you need to consider in your assumptions.