Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

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

Adobe_campaign1
Level 2
Level 2

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

1 Accepted Solution
Amit_Kumar
Correct answer by
Community Advisor
Community Advisor

Hi,

Please refer to the following screens:

Here is the url for docs

Hope this helps,

Amit 

View solution in original post

10 Replies
Vapsy
Employee
Employee

Hi Jameel,

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

Regards,

Vipul

Adobe_campaign1
Level 2
Level 2

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
Correct answer by
Community Advisor
Community Advisor

Hi,

Please refer to the following screens:

Here is the url for docs

Hope this helps,

Amit 

View solution in original post

Adobe_campaign1
Level 2
Level 2

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
Level 3
Level 3

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

A screenshot of the error would also be useful

Amit_Kumar
Community Advisor
Community Advisor

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

Adobe_campaign1
Level 2
Level 2

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
Level 2
Level 2

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
Level 2
Level 2

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
Community Advisor
Community Advisor

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?