Skip to Content
avatar image
Former Member

Copy records with match key

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Aug 09, 2017 at 07:09 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

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