Workflow Table Field size > 255 | Community
Skip to main content
dipendu_g
Level 5
June 4, 2024
Solved

Workflow Table Field size > 255

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

 

 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
AkshayAnand
AkshayAnandAccepted solution
New Participant
June 6, 2024

Hi @dipendu_g 

 

You can create a JavaScript library and then call it in any workflow, templates etc. by using the function loadLibrary.

loadLibrary

Use Javascript libraries in Adobe Campaign

 

Regards

Akshay

View reply

17 replies

CampaignerForLife
CampaignerForLife
Level 5
June 5, 2024

Try adding a new SQL Activity with this code:

ALTER TABLE <%= vars.tableName %> ADD LongString NCLOB;

and then insert in that LongString the concat 

Translate
dipendu_gAuthor
Level 5
June 5, 2024

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

Translate
AkshayAnand
AkshayAnand
New Participant
June 5, 2024

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

Translate
    dipendu_gAuthor
    Level 5
    June 5, 2024

    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

    Translate
    AkshayAnand
    AkshayAnandAccepted solution
    New Participant
    June 6, 2024

    Hi @dipendu_g 

     

    You can create a JavaScript library and then call it in any workflow, templates etc. by using the function loadLibrary.

    loadLibrary

    Use Javascript libraries in Adobe Campaign

     

    Regards

    Akshay

    Translate
      _Manoj_Kumar_
      _Manoj_Kumar_
      New Participant
      June 5, 2024

      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.

       

       

       

      Translate
           Manoj     Find me on LinkedIn
      dipendu_gAuthor
      Level 5
      June 5, 2024

      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 

      Translate
      _Manoj_Kumar_
      _Manoj_Kumar_
      New Participant
      June 5, 2024

      @dipendu_g  Can you share a screenshot of this setup?

      Translate
           Manoj     Find me on LinkedIn
      Terms & ConditionsAccessibility statement

      Loading footer...