I am trying to anonomise data for testing purposes by replacing it with an autonumber but as expected I am having some problems when using this on key fields
Original Code:
(ID1&'_'&ID2) asCombinedID,
Replace with Autonumber
AutoNumberHash
(ID1&'_'&ID2) asCombinedID,
The problem with this is thatCombinedIDis used in more that one table, so using autonumber breaks the links. I think I mapping table could be used, but I'm not sure how to go about this - any advice would be mych appreciated!
Autonumber(ID1&'_'&ID2) as CombinedID would create identical numbers for each ID1-ID2 combination during the same reload. It doesn't matter if you use it in different tables. You would still get the same values for the same combinations.
As long as all autonumbers are calculated in the same reload you get the same numbers. But if you store a table with calculated autonumbers in a qvd and load this in a later reload you can get numbers that are different from the autonumbers calculated during that reload. Autonumbers are not unique across reloads. If you need that you can try using the hashXXX functions.
Autonumber(ID1&'_'&ID2) as CombinedID would create identical numbers for each ID1-ID2 combination during the same reload. It doesn't matter if you use it in different tables. You would still get the same values for the same combinations.
As long as all autonumbers are calculated in the same reload you get the same numbers. But if you store a table with calculated autonumbers in a qvd and load this in a later reload you can get numbers that are different from the autonumbers calculated during that reload. Autonumbers are not unique across reloads. If you need that you can try using the hashXXX functions.
