since ‎18-09-2017
‎10-12-2019
jael91407431
Level 3
Re: List of functions
Avatar

brandonkern

brandonkern
- Adobe Campaign Standard
The page you specified no longer exists. The files you point to do not cover all the functions listed. For example FormatCurrency (, ) What are the values that are valid for ? I have triedn US, us, en-us, C0 etc

Views

58

Likes

0

Replies

0
Re: Dynamic coding with multiple values
Avatar

Raaghuik1996

Raaghuik1996
- Adobe Campaign Standard
sorry small correction that I can see blank data instead of Abc or fed which i am trying to display

Views

971

Likes

0

Replies

0
Re: Use of Sub-item option inside Query activity
Avatar

jael91407431

jael91407431
- Adobe Campaign Standard
Thank you so much. Will check it out for sure, and post any additional questions I may have.

Views

828

Likes

0

Replies

0
Re: What does $ mean?
Avatar

florentlb

Total Posts

1.1K

Likes

235

Correct Answer

239
florentlb
- Adobe Campaign Standard
Yes this is how I understood the docs. That said, in "body", you have to make sure that your database engine knows and can process 'vlookup' (I don't know much about that). If yes, then you should be good to go.Florent

Views

2.7K

Likes

0

Replies

0
Re: logInfo()
Avatar

jael91407431

jael91407431
- Adobe Campaign Standard
Super, thank you guys.

Views

923

Likes

0

Replies

0
Re: Vlookup formula in List of Functions
Avatar

florentlb

Total Posts

1.1K

Likes

235

Correct Answer

239
florentlb
- Adobe Campaign Standard
Any update on this?Florent

Views

2.4K

Likes

0

Replies

0
Re: "R.O" in SQL
Avatar

shrawans3153003

Employee

shrawans3153003
- Adobe Campaign Standard
As mentioned above "R0" is the alias which is generated automatically. As query is done here for Recipient table(NmsRecipient R0) so it "R0". if you query from Delivery table (NmsDelivery D0) it is "D0" and for broad log it is (NmsBroadLogRcp) "B0".Yes it is is best practice to use alias and most of RDBMS recommends this.You can find several articles on internet to know the benefits of using alias's .SQL Aliases

Views

938

Likes

0

Replies

0
Re: Creating Databases and tables using SQL Commands
Avatar

jael91407431

jael91407431
- Adobe Campaign Standard
Super, thank you Serge. Will give it a try.Much appreciated,Jae

Views

1.1K

Likes

0

Replies

0
Re: Creating Ad-hoc tables
Avatar

RamaRajesh

Employee

RamaRajesh
- Adobe Campaign Standard
Hi,A table can be created out of an existing table (schema) of the data model or a new one (new schema). Once the table is created, we can upload the data by querying the existing table or using a flat file.A list can be created out of an existing table by querying (select all recipients from recipient schema where country= USA) it. Or, by creating a list and updating the list with flat file data.So, a list can be created out of the adhoc data which is not present in the data model, already.For ...

Views

1.1K

Like

1

Replies

0
Re: Temporary lookup tables within the workflow
Avatar

christophec3473

christophec3473
- Adobe Campaign Standard
Hi,I'm not sure to understand but, I try to answer to you :If you use a upload data activity (if yours datas are in a Excel file for example)If you use a query activity (if yours data are in a schema on Adobe Campaign)You will obtain your temporary table.After that, you can use a union activity to join these data to recipient dataI answer to your question?Christophe

Views

683

Like

1

Replies

0
Re: AC Storage Engine
Avatar

jael91407431

jael91407431
- Adobe Campaign Standard
Great, thank you!

Views

785

Likes

0

Replies

0
Re: Basic questions regarding tables and fields in AC
Avatar

florentlb

Total Posts

1.1K

Likes

235

Correct Answer

239
florentlb
- Adobe Campaign Standard
Hi Jae,Sure:the yellow wheel indicates that the field is a calculated field (populated by transforming/calculating data from other fields)the red "!" means that the field is mandatory, can't be a null valuethe square icon indicates that this is a container, i.e. a group of fields, usually used for addressesFlorent

Views

571

Like

1

Replies

0
Re: Regex again in SQL
Avatar

Amit_Kumar

MVP

Amit_Kumar
- Adobe Campaign Standard
In Adobe campaign query can be achieved with like operator.Regards,Amit

Views

2.0K

Likes

2

Replies

0
Re: How to remove spacing between hyphen in Adobe Campaign
Avatar

florentlb

Total Posts

1.1K

Likes

235

Correct Answer

239
florentlb
- Adobe Campaign Standard
Hi JaeCould you resolve your issue?Let us know,Florent

Views

448

Likes

0

Replies

0
Re: Creating query expressions using regex
Avatar

jael91407431

jael91407431
- Adobe Campaign Standard
Hi Jean-Serge,Thank you for the reply.So if I want to exclude, for example, the following zip codes from my segment:EXCLUDE: "ZIP_CODE IN ( 48201, 48202, 48203, 48204,48205, 48206, 48207, 48208, 48209, 48210, 48211, 48212, 48213, 48214, 48215,48216, 48217, 48218, 48219, 48220, 48221, 48222, 48223, 48224, 48225, 48226,48227, 48228, 48229, 48230, 48231, 48232, 48233, 48234, 48235, 48236, 48237,48238, 48239, 48240, 48242, 48243, 48244, 48255, 48260, 48264, 48265, 48266,48267, 48268, 48269, 48272, 4...

Views

1.3K

Likes

0

Replies

0
Re: Adobe Campaign's Regular Expression Engine
Avatar

florentlb

Total Posts

1.1K

Likes

235

Correct Answer

239
florentlb
- Adobe Campaign Standard
Hi Jae,I believe Campaign uses PCRE as Regex engine.Hope this helps,Florent

Views

198

Likes

0

Replies

0
Re: Substring function
Avatar

florentlb

Total Posts

1.1K

Likes

235

Correct Answer

239
florentlb
- Adobe Campaign Standard
Hey,I'm locking this thread since this is a duplicate from Substring function.Florent

Views

904

Likes

0

Replies

0
Re: Substring function
Avatar

florentlb

Total Posts

1.1K

Likes

235

Correct Answer

239
florentlb
- Adobe Campaign Standard
Hi,Looks like the link changed. It's probably that URL now: Steps to create a query You can also use the search here: Browse Collection Florent

Views

2.4K

Likes

0

Replies

0
Likes given to