How to query the First 2 characters of count in adobe campaign? | Community
Skip to main content
Adobe_campaign1
Adobe_campaign1
Level 2
March 31, 2017
Solved

How to query the First 2 characters of count in adobe campaign?

  • March 31, 2017
  • 10 replies
  • 5100 views

Hi,

I need to fetch or query first 2 characters of Zip code as count  from one table in adobe campaign.

 

 

Thanks & Regards,

jameel.sk

    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 Amit_Kumar

    Hi,

    Please refer to the following screens:

    Here is the url for docs

    Hope this helps,

    Amit 

    10 replies

    vraghav
    Adobe Employee
    vraghavAdobe Employee
    Adobe Employee
    March 31, 2017

    Hi Jameel,

    You can make use of substring or left function available inside the advanced expression editor.

    Regards,

    Vipul

      Adobe_campaign1
      Adobe_campaign1Author
      Level 2
      March 31, 2017

      Hi,

      Vipul can you send me screen shot for this example or send me related  links for How to query the First 2 characters of count in adobe campaign?.

      Amit_Kumar
      Amit_KumarAccepted solution
      Level 10
      April 3, 2017

      Hi,

      Please refer to the following screens:

      Here is the url for docs

      Hope this helps,

      Amit 

      Adobe_campaign1
      Adobe_campaign1Author
      Level 2
      April 5, 2017

      Hi,

      Amit_kumar thank you for replay to this post..

      i tried the way u mentioned in post but i am getting error while executing the query.

      please check once.. any one help on this issue.. why am getting error..

      alistairk396804
      alistairk396804
      Level 3
      April 5, 2017

      Have you set the advanced options as per the second screenshot Amit provided?

      A screenshot of the error would also be useful

      Amit_Kumar
      Amit_Kumar
      Level 10
      April 7, 2017

      Did it worked? can you share the the error or the sample workflow with us so that we can help you?

      Adobe_campaign1
      Adobe_campaign1Author
      Level 2
      April 7, 2017

      Hi Amit_kumar,

      I am getting error while query running in the way you shared screen shot i followed i write query the query saved but when i try to run the query i ma geeting error the query will beacme red and process will be stoped.

      Adobe_campaign1
      Adobe_campaign1Author
      Level 2
      April 7, 2017

      Hi Amit_kumar,

      I am getting error while query running in the way you shared screen shot i followed i write query the query saved but when i try to run the query i am geeting error the query will became red and process will be stoped.

      Adobe_campaign1
      Adobe_campaign1Author
      Level 2
      April 7, 2017

      Hi Amit_kumar,

      I am getting error while query running in the way you shared screen shot i followed i write query the query saved but when i try to run the query i am geeting error the query will became red and process will be stoped.

      Amit_Kumar
      Amit_Kumar
      Level 10
      April 7, 2017

      Adobe campaign wrote...

      Hi Amit_kumar,

      I am getting error while query running in the way you shared screen shot i followed i write query the query saved but when i try to run the query i am geeting error the query will became red and process will be stoped.

       

      Go to the logs and post error logs here and just to be double sure have you set the advanced options as per the second screenshot?

      Terms & ConditionsAccessibility statement

      Loading footer...