Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

ALangridge
ALangridge
Online
  • 30-08-2022
    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 ...

    Type

    Questions

    Views

    115

    Likes

    2

    Replies

    0
  • 29-08-2022
    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. Y...

    Type

    Questions

    Views

    144

    Like

    1

    Replies

    2
  • 24-08-2022
    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 variabl...

    Type

    Questions

    Views

    90

    Like

    1

    Replies

    0
  • 08-08-2022
    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...

    Type

    Questions

    Views

    171

    Like

    1

    Replies

    1
  • 25-07-2022
    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 ...

    Type

    Questions

    Views

    87

    Likes

    0

    Replies

    0
  • 06-06-2022
    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.

    Type

    Questions

    Views

    217

    Like

    1

    Replies

    0
Top badges earned by ALangridge
Customize the badges you want to showcase on your profile