Adobe Analytics historical data to AEP

[gautham_madala]

Hello everyone, 
This is in follow up with https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-questions/adobe-analytics-historica...
I agree to Harveer's solution. However I have a problem; 
I have 10 report suits and I cannot be doing custom mapping since I have almost 1k components per report suite. That would just eat up all my time. 
Is there a better way to approach this via Query service. 
Problem is, auto_json in query is not working. so it would be hard to mention every column in query service to achieve what I need. 
Looking forward to hear If anyone know any hack that would help and have successfully completed migrating Adobe Analytics historical data to AEP on a custom schema.

[Harveer_SinghGi1 · Accepted solution]

Hi @gautham_madala ,

You have the option to import the data prep mapping from another data flow. So if the data transformations among your report suites are mostly common, then you can do a one time activity of adding custom mapping for one report suite and in other dataflows just import those mapping. Any variations can be added/updated.

Cheers!

[gautham_madala]

Thanks Harveer, 

If you can tell me where exactly I would be able to find this. Is this an API approach or in UI?