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

Avatar

Avatar

Adobe_campaign1

Avatar

Adobe_campaign1

Adobe_campaign1

30-03-2017

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

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

Amit_Kumar

MVP

Avatar

Amit_Kumar

MVP

Amit_Kumar
MVP

02-04-2017

Hi,

Please refer to the following screens:

Here is the url for docs

Hope this helps,

Amit 

Answers (9)

Answers (9)

Avatar

Avatar

Vapsy

Employee

Avatar

Vapsy

Employee

Vapsy
Employee

31-03-2017

Hi Jameel,

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

Regards,

Vipul

Avatar

Avatar

Amit_Kumar

MVP

Avatar

Amit_Kumar

MVP

Amit_Kumar
MVP

06-04-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?

Avatar

Avatar

Adobe_campaign1

Avatar

Adobe_campaign1

Adobe_campaign1

06-04-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.

Avatar

Avatar

Adobe_campaign1

Avatar

Adobe_campaign1

Adobe_campaign1

06-04-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.

Avatar

Avatar

Adobe_campaign1

Avatar

Adobe_campaign1

Adobe_campaign1

06-04-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.

Avatar

Avatar

Amit_Kumar

MVP

Avatar

Amit_Kumar

MVP

Amit_Kumar
MVP

06-04-2017

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

Avatar

Avatar

alistairk396804

Avatar

alistairk396804

alistairk396804

05-04-2017

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

A screenshot of the error would also be useful

Avatar

Avatar

Adobe_campaign1

Avatar

Adobe_campaign1

Adobe_campaign1

05-04-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..

Avatar

Avatar

Adobe_campaign1

Avatar

Adobe_campaign1

Adobe_campaign1

31-03-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?.