Hi @anishs2303 ,If any of the columns listed in the schema keys are blank, we might experience such issues. Could you please check that as well? If there are blank records in any of the key field, either it should be filled or the column should be removed from the keys.

Hi @andregonzalez, If it is still not resolved, could you please share some screenshots so that we might be able to find the root cause. We usually use the data loading and deduplication activities together.

Hi @andregonzalez , Have you selected the temporary schema in the dropdown as well (as in screenshot)?If you already have set this, please check the expression added in deduplication. Usually when adding columns from a data loading activity, we don't have to use the '@' in the expression. You may op...

Hi @alik98709228 ,Are you trying to insert records to subHisto table? According to my understanding, this schema is automatically updated during subscription or unsubscription actions. Also, this schema has the autopk=true, which means, it increment the id value each time during an insert. If you ar...

Hi @david--garcia ,Once you have the value in JavaScript, save it to an instance variable and then you can use in expression using $(instance/vars/xxx) format. 

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