Export Dataset without PII Data

[trojan_horse]

Hi,

I have an urgent request and would appreciate a quick response.

I'm trying to export a dataset from AEP to a third-party system (Azure Blob/S3/SFTP). The records in these datasets contain PII data, and I cannot select which fields to activate for the destination, as that option is not available in AEP. How can I export the datasets and all the records while skipping the activation of the PII fields?

I understand I can label the fields and create a governance policy to restrict activation, but will that restrict the activation of the entire record or just the specific field?

Thanks!

[NickMannion]

Have you tried us Access and data usage labels in a development environment and then generating an output file and seeing if the PII attributes are populating in that file?

[trojan_horse]

Yeah I tried it, and the output file does contain the PII fields

[GigiCotruta]

I suggest you the following thing: 

1. Create a new dataset
2. Use query services and copy from your original DS all the info you want to export to the destination. Make sure to use the same schema for this newly created dataset.
3. Export the newly created dataset.

[GigiCotruta]

If you need to export on a daily basis for example, you can schedule the query to run 1 hour before the export so it will always have the updated data.

[trojan_horse]

Don't we need data distiller for this? We don't have license for data distiller

[GigiCotruta]

You need it indeed. I would download the file, clean all the PII info then upload it again.

If you use labels, you won't be able to export any row that contains any PII, it filters it instantly, so it won't work for you.

[kautuk_sahni]

@trojan_horse Did you find the suggestions helpful? Please let us know if you need more information. If a response worked, kindly mark it as correct for posterity; alternatively, if you found a solution yourself, we’d appreciate it if you could share it with the community. Thank you!