Copy records with match key

[former_member481715]

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?

[former_member186338 · Accepted solution]

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.

[former_member481715 · Accepted solution]

How about intersections with zero value?

[former_member186338 · Accepted solution]

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."