since ‎03-08-2018
‎10-12-2019
preethamk581070
Level 1
Re: How to use querydef inside delivery activity
Avatar

naveens49375819

naveens49375819
- Adobe Campaign Standard
Thanks for the reply Preetham,We can create variables using javascript that too for only delivery templates using xtk.session.write method.RegardsNaveen S

Views

1.6K

Likes

0

Replies

0
Re: Changing incoming data in Data Loading/Update Data Function?
Avatar

preethamk581070

preethamk581070
- Adobe Campaign Classic
Hi alb52547777​,Alternatively, you can modify the data in transition using SQL activity like this,UPDATE <%= vars.tableName %> SET semail = RIGHT(semail, '10');UPDATE <%= vars.tableName %> SET semail = concat('61', semail) where length(semail) < 11 ;Where in the first line->semail is the column name I want to modify the data10 - I'm keeping last 10 digits in the column, removing anything beyond 10Second line ->I'm adding 61 at the beginning of the each record where the record length is less than...

Views

771

Likes

0

Replies

0
Likes from