You want to add the following new columns to the output of a direct mail file extract:
<firstparturl><firstName>-<lastName>
Firstparturl is already declared in a JavaScrips activity which will be executed before the targeting query: vars.firstparturl ='http:/ /www.amazingcompany.com/u='; The additional column for recipient called John Doe should look like this: http:/
/www.amazingcompany.com/u=John-Doe
How would you have created the expression in the query activity (Additional columns window) in order to meet the above mentioned requirement?