Hi @david--garcia ,I don't think the CounterValue function can be used inside JavaScript. You may use querydef to fetch the value var query = xtk.queryDef.create( <queryDef schema="xtk:counter" operation="select"> <select> <node expr="@name"/> <node expr="@value"/> </select> <where> <condition expr=...

Hi @SørenKring ,I don't know whether I got the problem correctly, but from what I understood, you will be sending 3 deliveries say a,b and c in each blast. Between each blast there will be 30d gap. You need to exclude the recipients that have registered on a particular service from the next email bl...

The development could be more easy if AC can support the npm packages and we can install and use it as we do in a NodeJS code.Using JavaScript is a great way to deal with may problems. But writing every code from scratch is tedious as well as error-prone. If we could use a trust-worthy package, we c...

Hi @Hari_07 ,If all you need to do is combine several columns to one, then I suppose you can do that in an enrichment or inside data extraction itself. The advanced expression editor provides a list of functions that you can use to check the data. To append the results to a single column, you may co...

Hi @david--garcia ,As per my understanding, the SqlDefault set in schema is applied only at the time of creation of that column. So if you have created the goal03 column with an sqlDefault, then it cannot be modified by changing in the schema itself. To change the default value you should run the fo...

Hi @4uSwan ,The split function actually returns an array of elements that consist of all the substrings that were next to a separator.For eg, if you run the following code, var testString = "hello world for test" ;var array = testString.split(" "); The resulting array variable would have content as ...

Hi @KotiSyamala ,I don't think you might be able to check the file header efficiently using data loading itself. I would suggest you use a shell script activity or a JS activity for this evaluation. The shell script could be likefileA="path to the file downloaded"fileB="path to file with header"head...

Hi @KotiSyamala ,I don't think you might be able to check the file header efficiently using data loading itself. I would suggest you use a shell script activity or a JS activity for this evaluation. The shell script could be as following: fileA="path to the file downloaded"fileB="path to file with h...

Then you may take the option3 to send delivery. You could create a custom schema for keeping the stakeholder emails and any other information required to identify stakeholders of each delivery. If there will be many stakeholders added frequently, you can create a workflow to update the details in th...

Hi @Data_guy ,From what I understand, I guess you have following options:If recipients of alert do require access to Adobe, you should need to create operator anyway. You may name the operators with any grouping pattern to identify them in a query and then send delivery to matching operators.If reci...