Popping in 3 years later to say thank you so much for saving me from bashing my head against this problem - turns out $noescaping() works perfectly! 

Ah gotcha! Didn't realize you had a single target to pull from - definitely the easier option there. I'd definitely keep the method I described in your pocket though - it works PERFECTLY for individual column values (eg: I enriched each record with the $ spent in the last week and now want a single ...

Hey! I'd achieve this by doing something like this in a JS activity.   var sql = "SELECT sum(" + vars.tableName + ".icolumnName) FROM " + vars.tableName; instance.vars.totalCount = sqlGetInt(sql); vars.tableName is set by the workflow and will contain the name of the temporary table you're creating....

Just a lil addition - if you want to use the variable within a split or something like that, you'd just have to use the following syntax in the expression editor:      $ - This is a string type value to be returned from the variable() - The info we are looking for vars - We’re looking at an event va...

Hey Vinay - I would probably try and get this working by using a javascript activity in the workflow to execute the script and store the output in a variable. Info on variables - you probably want to look at an instance variable: https://experienceleague.adobe.com/docs/campaign-classic/using/automat...

Hey Char - you'd be able to use an enrichment activity to create a link between the csv and the recipient records, have a look at the documentation HERE. My main thought about your plan here is that ZIP code is usually not a unique identifier - so would it really be a good way of getting an insight ...

Incredibly useful post! I can't believe this isn't outlined in official documentation anywhere.I just used this as the basis of a script to iterate rows and remove from a given list, which has massively streamlined a business process.