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

[#1]

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

[#2 · Accepted solution]

Hi,

Please refer to the following screens:

Here is the url for docs

Hope this helps,

Amit 

image3.PNG ‏474 KB

image1.PNG ‏139 KB

image2.PNG ‏254 KB

[#3]

Hi Jameel,

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

Regards,

Vipul

Left.png ‏55 KB

[#4]

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?

[#5]

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.

[#6]

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.

[#7]

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.

[#8]

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

[#9]

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

A screenshot of the error would also be useful

[#10]

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

error.jpg ‏23 KB

[#11]

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