Transactions table issue

[munna1317]

Hi Eveyone,

               I have a transaction table(Employee details) ,which contains Effective date,i have created a calendar in Transaction table .

History table contains Effective From and Effective To dates,I need to include history table changes to Transaction table.

History table Contains all the fields same as in Transaction table.

Any Suggestions would be greatly appreciated.

Please find the attached sample data for reference.

Regards,

A.Harish

[Peter_Cammaert · Accepted solution]

I'm still not sure that I understand what you plan to do with the calendar.

This one creates From/To periods from both your transactions and your historical records (example files from OP). The result is:

See attachment

Peter