Skip to Content
0

Copy records with match key

Aug 09, 2017 at 02:19 AM

55

avatar image
Former Member

Hello,

I have a question about this option in copy package. I thought it meant that it copy only the exact intersections. Let me give an example: I am copying data from 2017 Jan to 2017 Feb. 2017 Feb has data in account called A_200, if I am copying all accounts from 2017 Jan to 2017 Feb AND account A_200 has no data in 2017 Jan, should it overwrite Account A_200 with 0 in Feb? I thought Copy records with match key meant it will only copy exact intersections? Since in this case the exact intersection doesn't have any data in source, should it overwrite?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Vadim Kalinin Aug 09, 2017 at 07:09 AM
0

Copy records with match key will copy only records with data. Empty records will not be copied.

Try copy replacing data in same data region of Entity, Category, Time and Audit ID.

Or use clear script before copy.

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

How about intersections with zero value?

0

It's the question how you get the mentioned zero values! And If you run Light optimize with zero elimination - all zero records will disappear. In general you have to assume that zero records can be eliminated at any moment.

I recommend: "copy replacing data in same data region of Entity, Category, Time and Audit ID.

Or use clear script before copy."

0