Using workflow temporal table in post-processing workflow | Community
Skip to main content
Heku_
Heku_
Level 5
October 20, 2023
Question

Using workflow temporal table in post-processing workflow

  • October 20, 2023
  • 3 replies
  • 2292 views

Hello, i would like to use in the post-processing workflow of a delivery the temporal table generated here, in the previous activity of the delivery: 

Is there any way to do it?

Thank you in advance.

Héctor

 

@Manoj_Kumar_ @ParthaSarathy @Parvesh_Parmar @DavidKangni 

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

    3 replies

    ParthaSarathy
    Community Advisor
    ParthaSarathyCommunity Advisor
    Community Advisor
    October 20, 2023

    Hi @heku_ ,

    Use enrichment activity before your delivery activity. 

    Enrichment > Add data > Data linked to the filtering dimension > Data of the filtering dimension > (in Left) You can find the available fields of the temporary table generated in the previous activity of your delivery.

    Temporary table before Delivery:

    In Enrichment:

    ~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
    Heku_
    Heku_Author
    Level 5
    October 23, 2023

    Hello @parthasarathy, thanks for the reply. I'm talking about the post-processing workflow from the external account linked to the delivery.

      Marcel_Szimonisz
      Community Advisor
      Marcel_SzimoniszCommunity Advisor
      Community Advisor
      October 20, 2023

      Hello @heku_ ,

      i can think of two common ways how to do it:

      • With JS activity where you can queryDef entire population (if it is over 10k then might do skip to the other way below or while loop the population save it in vars. with JSON.stringify() and then read down the stream by JSON.parse() to make it array again and do postprocessing )
      • Fork your target and then after delivery feed it with the delivery to and join where you select the fork as primary target then do post processing

       

      Marcel Szimonisz

        Heku_
        Heku_Author
        Level 5
        October 23, 2023

        Hello @marcel_szimonisz , thanks for the reply. I'm talking about the post-processing workflow from the external account linked to the delivery.

          Marcel_Szimonisz
          Community Advisor
          Marcel_SzimoniszCommunity Advisor
          Community Advisor
          October 23, 2023

          Hello @heku_ ,

          you can try to save the population before delivery to the instance.vars. with use of xtkQueryDef (last one that cretas json array)  and with JSON.stringify the result. In the post processing try to read that instance.vars and convert it back to JSON array and do something. 

           


          Marcel

            CampaignerForLife
            CampaignerForLife
            Level 5
            May 6, 2024

            Maybe create a "temporal table" in your database, which will be override between executions. This temproal table will be a copy of the temporal table of the wkf.

             

            Hope this helped u

            Terms & ConditionsAccessibility statement

            Loading footer...