jael91407431

Hi,Thank you for the reply. I think your reply's accurate.So the body script for the vlookup function as I have it:body="vlookup($lookup_value, $Table_array, $Col_index_num, $Range_lookup)"/>is incorrect. As the vlookup as 4 arguments, the body script should be instead:body="vlookup($1, $2, $3, $4)"/>And during the function call, I would simply pass the column fields or xpath name that corresponds to each argument, i.e., since the vlookup syntax is: vlookup(lookup_value, Table_array, Col_index_n...

2.8K

Use of Sub-item option inside Query activity - Adobe Campaign Standard

Can anyone give an example of how one would use a sub-item inside the Add data/edit additional data option the query activity?As per Adobe's documentation, the add sub-item option lets you attach computed data to the collection. This lets you select the additional data from the collection or define aggregate calculations on collection elements.Can anyone give use case examples?

1.0K

Re: What does $ mean? - Adobe Campaign Standard

Hi,Adobe provides documentation on developing and importing custom functions:https://docs.campaign.adobe.com/doc/AC/en/CFG_API_Adding_additional_SQL_functions.htmlThis is the sample function raw code that Adode provides above:body="extract(year from age($1))-18"/>So I've developed the following vlookup function:body="vlookup($lookup_value, $Table_array, $Col_index_num, $Range_lookup)"/>So is the xpath syntax correct:body="vlookup($lookup_value, $Table_array, $Col_index_num, $Range_lookup)"/>Or i...

2.8K

Re: Vlookup formula in List of Functions - Adobe Campaign Standard

So the syntax is relatively simple:Where $lookup_value, $Table_arry, $Col_index_num, $Range_lookup would be the actual xpath fields (i.e., columns or fields) that represents the values ($xpath field (attribute or column) for lookup_value, $xpath field (attribute or column) for Table_array, $xpath field (attribute or column) for Col_index_num, $xpath field (attribute or column) for Range_lookup).Can someone validate this based on their own experience?

2.4K

What does $ mean? - Adobe Campaign Standard

Can anyone tell me what the php code ($) in the following documentation and elsewhere in AC documentation, mean?Is it php? If so, why is php embedded there? I thought Adobe Campaign does not process php.If not php, what is it? JavaScript? XML? What does it mean; I believe it is an assigned value, but I am trying to find it's origin (whether it's php, js, or xml. Can't find it online, other than php.):

3.1K

Re: logInfo() - Adobe Campaign Standard

Super, thank you guys.

959

logInfo() - Adobe Campaign Standard

Hi,Where can I view the logInfo(), results?

1.3K

Re: Vlookup formula in List of Functions - Adobe Campaign Standard

Hi,So I followed the documentation and formulated the following XML to be imported as a package into Campaign:Here is the raw code: ...which follows, I think, the documentation:Here is the template code Adobe provides in the documentation, those blocks of code to be replaced, I've highlighted in red: So my raw code replaces replaces the Adobe's template sample with my own code (in red😞 Yet, when I try to load, (import as a package) I am getting this error:Can anyone defi...

2.4K

Re: Vlookup formula in List of Functions - Adobe Campaign Standard

Yes, "funcList" worked. Found it in the data schema folder.Thank you.

11.2K

Re: Vlookup formula in List of Functions - Adobe Campaign Standard

Hi,I had attempted to search for "funclist" inside schemas folder and nothing shows up:Also, how can I pull up or show the directory path inside Campaign?

11.2K

Re: Vlookup formula in List of Functions - Adobe Campaign Standard

Hi,In the documentation, it points to a repository of functions inside Campaign:"Further function examples can be found in the predefined package "xtk\datakit\funcList.xml":Where in Campaign can I find the folder, "xtk\datakit\funcList.xml"; as I can't find "datakit" schema inside the "Data Schemas" folder:

11.2K

Re: Vlookup formula in List of Functions - Adobe Campaign Standard

I found it, the correct link:Adding additional SQL functions

11.2K

Re: Vlookup formula in List of Functions - Adobe Campaign Standard

HI,The link is broken. Can you provide the correct link?

11.2K

Vlookup formula in List of Functions - Adobe Campaign Standard

Hi,Can I create vlookup or hlookup formula inside our workflow?The List of Functions under Advanced Parameters doesn't contain either vlookup or hlookup functions:As you know vlookup (or Vertical lookup) searches down the first column of a range for a key and returns the value of a specified cell in the row found.Syntax: VLOOKUP(lookup_value, Table_array, Col_index_num, Range_lookup)So how can we create ad-hoc functions if they are not listed under List of Functions?

12.0K

Re: "R.O" in SQL - Adobe Campaign Standard

Thank you so much for the reply. In addition, what does "RO" stand for?And is it best practice of RDMS to use "RO" as an alias?

982

"R.O" in SQL - Adobe Campaign Standard

Can any one explain what the "R.O" mean when we generate a SQL expression:...and does Adobe Campaign generate the "R.O" be default in every SQL interpretation.Thank you.

1.9K

Re: Creating Databases and tables using SQL Commands - Adobe Campaign Standard

Super, thank you Serge. Will give it a try.Much appreciated,Jae

1.1K

Creating Databases and tables using SQL Commands - Adobe Campaign Standard

Hi,Can you create create AC databases and/or tables using SQL Commands? If so, how does one do so?

1.8K

Creating Ad-hoc tables - Adobe Campaign Standard

Hi,I'd like to throw this out the community to see the best response:I wish to create an ad-hoc table in our AC instance for the purpose of querying.From what I understand, I can either create a list or another table.A list is a temporary if a convenient way to query that contains data or entities (like indexing) but on a temporary basis. But a list's data can only contain data that's already contained in our database, is this correct? Secondly, ad-hoc tables (a table developed for certain workf...

1.4K

Temporary lookup tables within the workflow - Adobe Campaign Standard

Can we create lookup tables that can be joined to the recipient data within the workflow?In other words, can we create temporary lookup tables within the workflow for reporting and/or analytical purposes?

878

Re: AC Storage Engine - Adobe Campaign Standard

Great, thank you!

811

AC Storage Engine - Adobe Campaign Standard

Hi,Does anyone know which storage engine, if any, AC uses?I know we can purchase FDA (Federated Data Access) which, I assume, switches to a Federated storage engine, but which default storage engine does AC use, if any?Thanks.

902

Basic questions regarding tables and fields in AC - Adobe Campaign Standard

Hi,Can you explain what the following icons represent in AC?1. What does the yellow cogwheel represent inside the field icon?2. What does the red exclamation mark "!" mean inside the field icon?3. What does the white blank sqaure mean?Thanks.

777

Re: Regex again in SQL - Adobe Campaign Standard

Yes, exactly.

2.1K

Regex again in SQL - Adobe Campaign Standard

Hi,In MySQl, we have the ability to query using regex expressions, like:mysql > SELECT name, name LIKE '%ns' ends_in_ns -> FROM department; ...which yields:This example retrieves all the department names (fields) that name ends in “ns” as in "Operations," "Loans."My question is, can we also include regex expressions as part of the value (SQL equivalent of "LIKE" or "INCLUDES," etc. plus regex (for example, "j%n.com" to include all email addresses starting with "j" and ending in "n") to query in ...

2.2K

Re: Substring function - Adobe Campaign Standard

Yes, thank you so much and sorry for the dup.Jae

1.5K

Re: Creating query expressions using regex - 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...

1.3K

Re: How to remove spacing between hyphen in Adobe Campaign - Adobe Campaign Standard

Excellent! Jean_Serge!I will implement your recommendations, and await the results.Thank you so much as always!Sincerely,Jae

628

Re: Substring function - Adobe Campaign Standard

Hi Amit,Sorry for the duplicate post, I believe it was in error as I must of clicked on post it twice. Sorry and thank you and the forum moderators for your continual help!Sincerely,Jae

1.5K

Likes given to

User

Count

Likes from

User

Count

Guidelines

Cookie preferences