topic Re: Export DTV Grid data with a common DedupKey in DemandTools

Export DTV Grid data with a common DedupKey

dbennett — Tue, 21 Mar 2023 20:34:38 GMT

Hello,

I'd like to import my grid data into SF to do some more refinement and exclusions based on child records and comparison of values between certain fields. I plan to use SF reports for this and so I'd like to group a common DedupKey in SF. The export file I get out of DTV does not give me a common DedupKey. Part of the string is common but the entire string is not. How can I export common DedupKey values in DTV among the duplicate pairings?

Re: Export DTV Grid data with a common DedupKey

AnthonyValidity — Wed, 22 Mar 2023 12:34:45 GMT

Hi @dbennett,

When you Export Grid Data in the Dedupe module of DemandTools 5.x, you should have a column that lists the DedupeKey. You can also view the key, in the preview grid, by hitting the pancake symbol next to any column, then selectin the woffle looking symbo, and then searching for the keyword DedupeKey.

Here's my exported file from DemandTools 5.x and the column labeled DedupeKey.

If you are unable to perform this, please reach out to Support by using this form.

Re: Export DTV Grid data with a common DedupKey

dbennett — Wed, 22 Mar 2023 17:36:14 GMT

Thanks Anthony. I also get the dedupkey exported, but my keys are not identical values. Even in your example, the 3rd pair down does not have identical values. Why are pairs identical and others are not?