How to add additional field in targetdata using script | Community
Skip to main content
C
ckumari12
Level 3
January 27, 2021
Solved

How to add additional field in targetdata using script

  • January 27, 2021
  • 2 replies
  • 2139 views

Hello,

I am working on a requirement where i need to add an additional field 'field1' (not part of recipient or campaign). I need to  use field1 field in target mapping and store this in broadlog (created an custom field to store).

I need to create this field and set its value dynamically because different campaigns/workflow can have different values.

 

I can't do this query activity because the end-user won't be able to do this everytime they select a new query activity and enrich it.

 

What we can do is to set a delivery in initialization script tab of delivery template and then use it in delivery whenever user is configuring delivery using a delivery template.

 

I tried adding below code:

 

sqlExec("Alter table "+ vars.tableName + " ADD COLUMN icampaignFlag INT");

sqlExec("Update " + vars.tableName + " set icampaignFlag =" + 1);

 

But this field is not showing in target data. May be because there is no adobe name for this field.

How can we see this field in targetdata?

 

Can someone help?

 

@2024469 

@637206 

 

 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Jonathon_wodnicki

Hi,

 

Target schema can be altered with js but it's not for the faint of heart. Easier to prepopulate workflow template with query that has mapped field.

If the data doesn't vary by recipient, does it need to be in broadLog?

 

Thanks,

-Jon

2 replies

Jonathon_wodnicki
Community Advisor
Jonathon_wodnickiCommunity AdvisorAccepted solution
Community Advisor
February 2, 2021

Hi,

 

Target schema can be altered with js but it's not for the faint of heart. Easier to prepopulate workflow template with query that has mapped field.

If the data doesn't vary by recipient, does it need to be in broadLog?

 

Thanks,

-Jon

    saikatk2447661
    saikatk2447661
    Level 4
    February 10, 2021

    Hi @jonathon_wodnicki ,

     

    Could you please share the process of altering Target schema with js? I remember you mentioned two js functions (something like generateSchema) in a forum post here but unfortunately I could not find that post/comment anymore. I would love to explore them.

     

    Thanks in advance,

    Saikat

    Sukrity_Wadhwa
    Community Manager
    Sukrity_WadhwaCommunity Manager
    Community Manager
    February 15, 2021
    Hi @ckumari12, Were you able to resolve this query or do you still need more help here? Do let us know. Thanks!
    Sukrity Wadhwa
    Terms & ConditionsAccessibility statement

    Loading footer...