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

Forum|Forum|8 years ago
March 31, 2017
10 replies
5098 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

Amit_Kumar

New Participant

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?

Adobe_campaign1Author

New Participant

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_campaign1Author

New Participant

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_campaign1Author

New Participant

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.

Amit_Kumar

New Participant

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