since ‎18-09-2017
‎10-12-2019
jael91407431
Level 3
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

831

Likes

0

Replies

0
Re: What does $ mean?
Avatar

jael91407431

jael91407431
- Adobe Campaign Standard
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...

Views

2.7K

Likes

0

Replies

1
Use of Sub-item option inside Query activity
Avatar

jael91407431

jael91407431
- 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?

Views

1.0K

Likes

0

Replies

3
Re: What does $ mean?
Avatar

jael91407431

jael91407431
- 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...

Views

2.7K

Likes

0

Replies

3
Re: Vlookup formula in List of Functions
Avatar

jael91407431

jael91407431
- 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?

Views

2.4K

Likes

0

Replies

1
What does $ mean?
Avatar

jael91407431

jael91407431
- 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.):

Views

3.0K

Likes

0

Replies

5
Re: logInfo()
Avatar

jael91407431

jael91407431
- Adobe Campaign Standard
Super, thank you guys.

Views

925

Likes

0

Replies

0
logInfo()
Avatar

jael91407431

jael91407431
- Adobe Campaign Standard
Hi,Where can I view the logInfo(), results?

Views

1.3K

Likes

0

Replies

3
Re: Vlookup formula in List of Functions
Avatar

jael91407431

jael91407431
- 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...

Views

2.4K

Like

1

Replies

2
Re: Vlookup formula in List of Functions
Avatar

jael91407431

jael91407431
- Adobe Campaign Standard
Yes, "funcList" worked. Found it in the data schema folder.Thank you.

Views

11.1K

Likes

0

Replies

1
Re: Vlookup formula in List of Functions
Avatar

jael91407431

jael91407431
- 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?

Views

11.1K

Likes

0

Replies

4
Re: Vlookup formula in List of Functions
Avatar

jael91407431

jael91407431
- 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:

Views

11.1K

Likes

0

Replies

6
Re: Vlookup formula in List of Functions
Avatar

jael91407431

jael91407431
- Adobe Campaign Standard
I found it, the correct link:Adding additional SQL functions

Views

11.1K

Like

1

Replies

0
Re: Vlookup formula in List of Functions
Avatar

jael91407431

jael91407431
- Adobe Campaign Standard
HI,The link is broken. Can you provide the correct link?

Views

11.1K

Likes

0

Replies

0
Vlookup formula in List of Functions
Avatar

jael91407431

jael91407431
- 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?

Views

11.9K

Like

1

Replies

13
Re: "R.O" in SQL
Avatar

jael91407431

jael91407431
- 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?

Views

934

Likes

0

Replies

0
"R.O" in SQL
Avatar

jael91407431

jael91407431
- 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.

Views

1.9K

Like

1

Replies

3
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
Creating Databases and tables using SQL Commands
Avatar

jael91407431

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

Views

1.8K

Like

1

Replies

3
Creating Ad-hoc tables
Avatar

jael91407431

jael91407431
- 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...

Views

1.4K

Like

1

Replies

1
Temporary lookup tables within the workflow
Avatar

jael91407431

jael91407431
- 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?

Views

852

Likes

0

Replies

1
Re: AC Storage Engine
Avatar

jael91407431

jael91407431
- Adobe Campaign Standard
Great, thank you!

Views

785

Likes

0

Replies

0
AC Storage Engine
Avatar

jael91407431

jael91407431
- 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.

Views

876

Likes

0

Replies

2
Basic questions regarding tables and fields in AC
Avatar

jael91407431

jael91407431
- 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.

Views

751

Like

1

Replies

1
Re: Regex again in SQL
Avatar

jael91407431

jael91407431
- Adobe Campaign Standard
Yes, exactly.

Views

2.0K

Likes

0

Replies

1
Regex again in SQL
Avatar

jael91407431

jael91407431
- 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 ...

Views

2.2K

Like

1

Replies

3
Re: Substring function
Avatar

jael91407431

jael91407431
- Adobe Campaign Standard
Yes, thank you so much and sorry for the dup.Jae

Views

1.4K

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: How to remove spacing between hyphen in Adobe Campaign
Avatar

jael91407431

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

Views

605

Likes

0

Replies

0
Re: Substring function
Avatar

jael91407431

jael91407431
- 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

Views

1.5K

Likes

0

Replies

0
Likes given to