Change Data Capture without modification date

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Would request if somebody can help me with this:

I have a source table coming from a FoxPro system like the one below:

ID	Name	Region
001	ABC	New York
002	DEF	Miami
003	GHI	London

Now the Value of 'Region' is changed randomly without any information - this affects my application since I've applied Section Access based on values of 'Region'. e.g. if a user is given access to data related to 'London' and the 'London' value is replaced with 'New London' - that user would not find any data.

I'm required to find a solution that "maintains historical data & records any changes made in the Region field. Also if it sends out alerts/emails that would be great.

Note:

1. There is no modification time or date available in the table/source.

2. This table is scheduled for reload daily.

Would really appreciate any help on this.

Thanks

Harry

topic Change Data Capture without modification date in QlikView

Change Data Capture without modification date