Hi there,I tried using the script below in the JS activity, but I encountered the error: 'it is not contained in either aggregate function or GROUP BY clause.' I am now attempting to use a subquery and will update you on the progress. Please can you let me know if it can be achievable without using ...

Hi @ParthaSarathy I tried using the script below in the JS activity, but I encountered the error: 'it is not contained in either aggregate function or GROUP BY clause.' I am now attempting to use a subquery and will update you on the progress. var fquery = xtk.queryDef.create ( <queryDef schema = {v...

 Thank you @ParthaSarathy Is there a method to group them by the initial characters of the segment code? For example, if the segment code is "scen3_IS_DELETED," this value should be placed under the row labeled "Scen3," with a column named "IS_DELETED" set to 1 that gets the data frominstance.vars.c...

Thank you @ParthaSarathy This helped. Now, I need to select a few columns and send an alert email that includes the total number of customers based on each scenario.For example:My segment codes include:Scenario2a_OptOutScenario2a_IS_DELETEDI am unsure how to break this down further and include the t...

Hi @LakshmiPravallika , Thank you. It worked, but for one delivery, the decimal is still not rounding off to two decimal places. Please advise.   

Hi there,  I have a scenario where I need to share data about unpicked customers during a workflow execution that runs on a scheduler.I have multiple scenarios, each with different filters. To handle these, I have added query activities and split activities to filter and separate records with incomp...

Hi team,  Is there a way to round the decimal points for the function below:(percent([indicators/@estimatedRecipientOpen],[indicators/@successWithoutSeeds]))*100 I tried adding round:round((percent([indicators/@estimatedRecipientOpen],[indicators/@successWithoutSeeds]))*100, 2)but it throws an error...

Hi @_Manoj_Kumar_ , The above code indexOf method === -1 worked for me. 

Hi @_Manoj_Kumar_ Thank you for your reply. If I do not want to use the my_lang variable, can I implement something like the following? I need to test this. var features = '21,22,23,24,25,26,27,28,29,30,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51' <% if (!(targetData.schema...

Hi @vprasad ,I was able to achieve this with the help of split activity after enrichment. Thank you for your response.