As shown by Table A and B, I have fields in respective tables that gets added
when a new ProductID or Contract NO is added in the data source. But there is
no dimension that "indicates" that a new ProductID or ContractNO has been added.
Usually this addition is made easier to identify with a transaction date, but we do not
have that field. The only way to know that a new ID or ContractNO has been introduced
is by the field itself. Each ProductID & ContractNO are unique. But then again, unique within
their table only. Below is their relatioship.
ProductID Contract NO
What I need is after reloading at any time during the day,
I want a straight table to be populated with 3 fields as in the
pic below, if there has been a new ProductID and or Contract NO.
Can this be done? So basically if a new field value for above 2 exists,
the reload should populate this straight table. And in coourse of time,
for eg, in a month, I should have a Table with multiple lines populated.