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
Amit_Kumar
MVP
Amit_Kumar
MVP
02-04-2017
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
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?
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.
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.
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.
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?
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
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..
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?.