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
BedrockMission!

Learn More

View all

Sign in to view all badges

Tarquinius
Community profile Tarquinius Level 1
Job title here
Location here
1 BADGE
Level 1

Level 1

Learn more
Joined the community 27-09-2019 2:11:11 AM
Offline
Top badges earned by Tarquinius
Customize the badges you want to showcase on your profile
Re: Dropping Data from a Temp Table
Avatar
Validate 1
Level 1
Tarquinius
Level 1

Likes

0 likes

Total Posts

4 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
Tarquinius
- Adobe Campaign Classic
Thanks for the response @adithyacs86 Sorry. I may not have explained myself very well though! 🙂 The list is reused over and over each time the workflow is triggered. The problem is when the data is loaded into a temp table within the workflow, it's not getting dropped once the workflow has completed (probably because the workflow has a continual delivery and therefore never truly 'ends'). I don't want to purge the list - just the temp list load from the workflow (temp:readGroup by the looks of ...

Views

259

Likes

0

Replies

1
Dropping Data from a Temp Table
Avatar
Validate 1
Level 1
Tarquinius
Level 1

Likes

0 likes

Total Posts

4 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
Tarquinius
- Adobe Campaign Classic
Hi, I have a continual delivery workflow that is looking for an External signal to activate.As part of the workflow, I pull in a List for lookups against c1.4 million rows. Not ideal but best way of circumventing an issue. The workflow runs and sends the emails.However the list never seems to get dropped but holds the data in a temp table (temp:readGroup). Is there anyway of dropping this data via a JS node once the email has sent? It's putting strain on the server since the workflow never reall...

Views

336

Likes

0

Replies

6
Re: Converting and altering value in personalisation block
Avatar
Validate 1
Level 1
Tarquinius
Level 1

Likes

0 likes

Total Posts

4 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
Tarquinius
- Adobe Campaign Classic
Absolute legend - thanks if I wasn't direct enough I was struggling to explain what I wanted - it was the second part of your solution - subtracting £10 from the string value - which you have expertly resolved! Thank you! 🙂 The code is really useful too, as now I can work out what it's doing so I can understand it for future! Thanks again.

Views

4.6K

Likes

0

Replies

0
Converting and altering value in personalisation block
Avatar
Validate 1
Level 1
Tarquinius
Level 1

Likes

0 likes

Total Posts

4 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
Tarquinius
- Adobe Campaign Classic
Hi, First post, new to the platform so hoping so clever people can point me in the right direction! I'm trying to set up a personalisation block so I can convert a variable - but I'm struggling! I have an XML string, I'm trying to extract a cost value (e.g. £1,509.10) from the string convert into a number (1,509.10), so I can subtract 10 from it). Any idea how to do this. I've got as far as defining a variable for the XML string in the email - and I can pull out the variable and get rid of the £...

Views

4.7K

Likes

0

Replies

4