1. Design you query2. Add a javascript node to the end3. Create a loop in javascript to process the targetData in batches of say 1k, using queryDef method4. Script your content and write it to the local SFTP folder via javascript File object https://docs.adobe.com/content/help/en/campaign-classic/technicalresources/api/f-saveFile.html

Hi, I think the confusing thing here is the person answering previously is making the assumption that you have a custom personalisation block on your instance called "toSmartCase" which is likely not available on your installation. What they have done is created a personalisation block external to the template called "toSmartCase" which contains some custom javascript function .toSmartCase(). They are then asking you to include this and it does not exist. I have 2 solutions for you and you can t.toProperCase() function to all strings in the template.You can exteneralise this if required, but you would have to add it to a personalition block, and then include it.I would suggestion for now just to add it to your template.-->...