Below is the JS i have written ..var query = xtk.queryDef.create(      <queryDef schema="temp:enrich4" operation="select">        <select>         <node alias="@d1"  expr="[Product1/@Description]"/>    <node alias="@d2" expr="[Product2/@Description]"/>    <node alias="@d3" expr="[Product3/@Descripti...

Hi Linda, Thanks for your response ..Below is the full context behind this XML script ..I have a workflow which identifies the products purchased by each customer   and ranks the spend on each product.Then there is a delivery ,which presents the products as per their spend (Rank) and the products th...

Hi Team , could you please advise ,if there is something wrong with the below script ..I have tried to use it and its not working ...please suggest ..xtk.session.Write(<enrich4xtkschema="temp:enrich4" _key="@id" id={responder.@id} > <Product2description={secondArray[1]}/> <Product3description={secon...

Thanks Linda,I have one more question :I need help with the below statement, I trying to figure out what is wrong with it :countdistinct(Iif(DateOnly(@sapInvoiceDate) > DateOnly(MonthsAgo(12) && DateOnly(@sapInvoiceDate) < GetDate() ),@id,0) )RegardsShiva

Hi team,I have the below query written, however I keep getting an error.iif((([expr1438750422]  Between 1 And  9)  And [expr1438752997] <=12 ) And ([expr1438750422] >0 And ([expr1438752958] <= 6)),"Active-F","NULL")any ideas would be great..thanksShiva