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?
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:
It actually refers to the location in the server where this funclist.xml is present. It's under datakit/xtk/eng folder on the server.
from the console you can simply search for funclist under schemas and it should be there.