Hi @Sanjana12 You can group the columns with group by targeting dimensions and proceed with your results for further operations. Regards

Hi @Sanjana12 As you are targeting your recipient schema, hence those become your targeting dimensions. So when you are doing GroupBy Targeting Dimension it is giving the same result are your are getting previously by your methods. Regards

Hi @Prateek789 You can try storing the ctx variables in some variable (eg. var A = ctx.abc) and then try to call it in the Post event or you can also try storing the output in some Option Variables and use them in your workflow. Regards

Hi @Sanjana12    Could you please help us with the error you are encountering to get a clear picture.   Regards 

Hi @Sanjana12    As suggested by @ParthaSarathy, please check the reconciliation keys are mapped correctly in update data activity and also try pulling the same in update fields.   Regards

Hi @SorenDP    Still the issue persists? This is weird.  Apologies for the typo in the code . var query = xtk.queryDef.create( <queryDef schema="kap:series" operation ="select"> <select> <node expr="@url"/> <node expr="description"/> </select> <where> ...

Hi @SorenDP    Could you please check if the schema has been committed to the database through Update DataBase Structure? Also in the structure tab of your schema, you may find 3 dots on right hand side below corner , please click on that and see what's the name adobe has generated for the desired ...

Hi @SorenDP    Memo Fields will not be accessed by giving  '@' because when try to see the display advanced field you won't be able to see '@' instead it just gives the name. Hence you can try the below code. var query = xtk.queryDef.create( <queryDef schema="kap:series" operation ="select"> ...

Hi @TJFORCE68    You can use the below code in your Query activity in advance selection :- Day(DateOnly(GetDate())) - (Day(DateOnly(GetDate())) - 1 )+'/'+ Iif((Month(DateOnly(GetDate())) + 2) > 12, (Month(DateOnly(GetDate())) + 2) - 12 , (Month(DateOnly(GetDate())) + 2)) + '/' + Iif((Month(DateOnly(...

Hi @dhfw    Thank you for your explanation. As mentioned in my previous comment, you can use bound parameters with $() for secure transfer as instance variables can't be used. (instance.vars.x or vars.x will throw undefined error). Repasting the links :- Documentation of binding the parameter. For m...