Personalization block which populates the value in anchor tag

[Ramaswami]

Hi Team, 

i am just loading a file and sending emails to the emails which are there in the file loaded and the people which are there in file i am not importing them to recipient schema i am just using the target mapping as external and sending emails. 

But while sending the emails i will have to pass a link to each profile based on the values loaded from excel. 

Sample file which i loaded: 

So in the email there will be a unique link and we need to pass the first letter of the job category in that link. In the above case i need to pass 'C' to the link. 

I am writing two personalization blocks : 

Block1 internal name : prdVIEW10011

<%

if(dataSource.Job_Category=='Corporate') {

%>https://XXXXXXXX/en-US?type=1&jobCat=<%@ include view='prdVIEW10015' %> <%

} else if(dataSource.Job_Category=='Call Center'){

%> https://XXXXXXX/en-US?type=2&jobCat=<%@ include view='prdVIEW10015' %> <%

} else if(dataSource.Job_Category=='test'){

%> https://XXXXXX/en-US?type=3&jobCat=<%@ include view='prdVIEW10015' %> <%

} else {

%> https://XXXXX/en-US?type=0&jobCat=<%@ include view='prdVIEW10015' %> <%

}

Block 2 (prdVIEW10015) which i am using in block 1 : 

<% if ( dataSource.Job_Category != '' ) { %>
<%=dataSource.Job_Category[0]%>
<% } %>

i am using block 1 in email delivery : 

The link should be like : https://XXXXX/en-US?type=0&jobCat=C

and i am getting link this : https://XXXXX/en-US?type=0

[anupk2111]

If this is not a reusable logic, why don't you use a targetData field to personalize the URL instead of creating a personalization block?

You could just define the same logic you have in the personalization block, in an enrichment activity in the workflow. 

Let me know if that works for you. 

[Ramaswami]

Hi @anupk2111,

There are about 6 columns in the excel where i need to apply some logic for each column.

for example : get firstname column from excel and only take first 3 letters and pass in url, get the country name from excel and remove spaces and pass in url and so on.. 

i don't know if we can write a javascript function and pass the return value into the url. If that functionality supports then it would be easier.