Hi Team,
I am using a query in a workflow that group records and concats field. The result of this concat field sometimes extend beyond 255, which triggers an error in the Query workflow activity, is there a way to accommodate characters > 255, in a temporary worktable.
The idea is to use that conca field later in the workflow activity to do further processing
I tried using the Edit Schema, but not sure how to go about it ?
Please suggest some alternatives
Regards,
DG
Solved! Go to Solution.
Topics help categorize Community content and increase your ability to discover relevant content.
Views
Replies
Total Likes
Hi @dipendu_g
You can create a JavaScript library and then call it in any workflow, templates etc. by using the function loadLibrary.
Use Javascript libraries in Adobe Campaign
Regards
Akshay
Hello @dipendu_g
You can use the XML Memo field from Recipient schema in an Enrichment and change the alias according toy our requirement and use this field. This newly created field will inherit the length of the XML Memo field which is 2000 characters.
Views
Replies
Total Likes
Hi @_Manoj_Kumar_ ,
Thanks for your reply, I am using a user defined SQL Function(xtk:funclist), that creates a string > 255 characters. I am still getting the String truncate error.
Regards,
DG
Views
Replies
Total Likes
@dipendu_g Can you share a screenshot of this setup?
Views
Replies
Total Likes
Views
Replies
Total Likes
The setup looks alright. What is the error?
Views
Replies
Total Likes
ODB-240000 ODBC error: String '...' is too long and would be truncated SQLState: 22000
The String size is greater than 255, so this error, else it works fine
Regards,
DG
Views
Replies
Total Likes
Can you please share a screenshot of how this is configured in enrichment?
Views
Replies
Total Likes
Views
Replies
Total Likes
@dipendu_g instead of creating a new output column use the existing XML memo to write the function
Views
Replies
Total Likes
Hi @_Manoj_Kumar_ ,
Can you show me with an example as the StringAgg function is using the @firstName field of recipient.
It will help
Regards,
DG
Views
Replies
Total Likes
Views
Replies
Total Likes
Hello @dipendu_g looks like this is not possible with enrichment.
You will have to use JavaScript for concat and then use the variables to print data in delivery
Hi @dipendu_g
You can use the JavaScript to concatenate the string as Below:-
var result = '';
var name = new Array("A1", "A2", "A3");
for (var i=0; i<name.length; i++){
fName = name[i];
logInfo ("fName "+name[i]);
result = result.concat(fName, ",");
logInfo ("Result "+result);
}
Regards
Akshay
Hi @AkshayAnand, @_Manoj_Kumar_,
The requirement is to create a new SQL function so that can be easily used by the Campaign Managers, like other SQL functions
Is 255 Characters max in case of temporary table created in workflow, or can they be extended to hold larger value
Regards,
DG
Views
Replies
Total Likes
Hi @dipendu_g
You can create a JavaScript library and then call it in any workflow, templates etc. by using the function loadLibrary.
Use Javascript libraries in Adobe Campaign
Regards
Akshay
Try adding a new SQL Activity with this code:
ALTER TABLE <%= vars.tableName %>
ADD LongString NCLOB;
and then insert in that LongString the concat
Views
Replies
Total Likes
There is no change, I mean no column is added after the transition. I used Varchar instead of NCLOB.
Can somebody please post the setup, if possible
Regards,
DG
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies
Views
Likes
Replies